Interview Questions on .Net and Msbi Technologies

11/08/2012

How to Get Previous Month End Date in SQL Server

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

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )