Friday, August 2, 2013

how to get the last day of a month in sql server

To get last day of a month in sql server

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)