Thursday, 6 March 2014

Select First Date of Current year in Sql Server

SELECT DATEADD( yy, DATEDIFF( yy, 0, getdate() ), 0) AS FirstDateOfYear


No comments:

Post a Comment