Friday, August 2, 2013

how to get the first day of a month using sql server

we can get the first day in a month using the query

SELECT CONVERT(VARCHAR(10),DATEADD(dd,-(DAY(GETDATE())-1),GETDATE()),103)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)