Search This Blog

Wednesday, November 28, 2012

Find Last Day of Previous Month SQL Server

SQL Server > Built-in Functions > DATEADD Find Last Day of Previous Month

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