Get days of a month in SQL

g_p_l

0/5 (0 vote)

Feb 4, 2010

CPOL

4980

@dt is a datetime valuederive the first of this month, add a month to itthen subtract 1 day to get the last day of this monthselect days_of_month=day( dateadd(d,-1, dateadd(m,1, dateadd(d,1-day(@dt), @dt) ) ) )

@dt is a datetime value derive the first of this month, add a month to it then subtract 1 day to get the last day of this month

select days_of_month=day(
        dateadd(d,-1,
            dateadd(m,1,
                dateadd(d,1-day(@dt), @dt)
                )
            )
        )