0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for scientists using computers to solve scientific problems

select top 20 Title, CreationDate, DATEDIFF(YEAR,CreationDate,GETDATE())
from Posts
WHERE year(CreationDate) - year(GETDATE()) = 3
AND month(CreationDate)=month(GETDATE())
AND day(CreationDate)=DAY(GETDATE());

fork query

edited apr 26 18

created apr 26 18 anonymous