select TOP(DATEDIFF(day, '2020-12-31', CONVERT (date, GET...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

select TOP(DATEDIFF(day, '2020-12-31', CONVERT (date, GETDATE())))
    DATEADD(DD,1-ROW_NUMBER() OVER (ORDER BY Id), CONVERT (date, GETDATE())) as d_date
  from Posts

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results