Interview Questions on .Net and Msbi Technologies

11/08/2012

how to get Current Month Last Date in SQL Server

SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )