0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

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

fork query

edited oct 3 23

created oct 3 23 anonymous