Thursday, 6 March 2014

Select Last Date of Current year in Sql Server

SELECT DATEADD(yy, DATEDIFF(yy, 0, getdate()) + 1, -1) AS LastDateOfYear
Posted by at
Labels: , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)