how to get which month ends on which number

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

DECLARE @givenDate AS DATETIME

SET @givenDate = '2011-11-05'

SELECT DATEADD(d,-1,DATEADD(mm, DATEDIFF(m,0,@givenDate)+1,0)), --As date

DAY(DATEADD(d,-1,DATEADD(mm, DATEDIFF(m,0,@givenDate)+1,0))) --As days

DECLARE @givenMonth AS INT

SET @givenMonth = '11'

SELECT DAY(DATEADD(d,-1,DATEADD(mm, DATEDIFF(m,0,(DATEADD(mm, @givenMonth-1, 0)))+1,0)))

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/