Monday, August 5, 2013

how to get the first day of current year in sql server

to get the first day of current year using sql

SELECT DATEADD(YY,DATEDIFF(YY,0,GETDATE()),0)

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)