Thursday 31 December 2015

QUERY TO FIND LAST DATE OF THE CURRENT MONTH / PREVIOUS MONTH / NEXT MONTH

-----QUERY TO FIND LAST DATE OF THE CURRENT MONTH / PREVIOUS MONTH / NEXT MONTH
USE ROHAN
GO
SELECT DATEADD(DAY,-DAY(DATEADD(MONTH,1,CONVERT(DATE,GETDATE()))),DATEADD(MONTH,1,CONVERT(DATE,GETDATE()))) AS'LAST DAY OF CURRENT MONTH',
DATEADD(DAY,-DATEPART(DAY,CONVERT(date,GETDATE())),CONVERT(DATE,GETDATE())) AS 'LAST DAY OF PREVIOUS MONTH',
DATEADD(DAY,-DATEPART(DAY,DATEADD(MONTH,2,CONVERT(DATE,GETDATE()))),DATEADD(MONTH,2,CONVERT(DATE,GETDATE()))) 'LAST DAY OF NEXT MONTH'
---- DYNAMIC SET THE DATED
DECLARE @SETDATE DATE = GETDATE()
SELECT DATEADD(DAY,-DAY(DATEADD(MONTH,1,CONVERT(DATE,@SETDATE))),DATEADD(MONTH,1,CONVERT(DATE,@SETDATE))) AS 'LAST DAY OF GIVEN CURRENT MONTH',
DATEADD(DAY,-DATEPART(DAY,CONVERT(date,@SETDATE)),CONVERT(DATE,@SETDATE)) AS 'LAST DAY OF GIVEN PREVIOUS MONTH',
DATEADD(DAY,-DATEPART(DAY,DATEADD(MONTH,2,CONVERT(DATE,@SETDATE))),DATEADD(MONTH,2,CONVERT(DATE,@SETDATE)))'LAST DAY OF GIVEN NEXT MONTH'



No comments:

Post a Comment