Thursday, 28 February 2013

SQL SERVER – Find First Day of Any Month – Current Previous Next --FirstDay_PreviousMonth SELECT DATEADD(mm, DATEDIFF(m,0,getdate())-1,0) --FirstDay_CurrentMonth SELECT DATEADD(mm, DATEDIFF(m,0,getdate()),0) --FirstDay_NextMonth SELECT DATEADD(mm, DATEDIFF(m,0,getdate())+1,0) SQL SERVER – Find Last Day of Any Month – Current Previous Next ----Last Day of Previous Month SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) LastDay_PreviousMonth ----Last Day of Current Month SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)) LastDay_CurrentMonth ----Last Day of Next Month SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0))

No comments:

Post a Comment