Get number of days in a month

[rsrinivasan]

Hi all,

Is SQLSERVER have any built in function to get number of days for a given month?

Thanks,

[deepuv04]

Hi all,

Is SQLSERVER have any built in function to get number of days for a given month?

Thanks,

use the following query to get number of days in a given month

declare @Date datetime
select @Date = Getdate()
 
select datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast(cast(year(@Date) as varchar)+
        '-'+cast(month(@Date) as varchar)+'-01' as datetime))))
 

my logic is i am taking the year and month of the given date and adding 1 to the month, then append 01 at the end so that we are moving to the 1 st of the next month. from the result i am moving one day back which is last day of the given month. if we take the day part from the final value which is number of days in a given month

[ck9663]

Here's another one:

DECLARE @dtDate DATETIME
    SET @dtDate = getdate()
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,@dtDate)+1,0))
 

-- CK