Over a million developers have joined DZone.

Days In Month In SQL Server (without User Functions)

DZone's Guide to

Days In Month In SQL Server (without User Functions)

Free Resource

SELECT CASE WHEN MONTH(DateTime) IN (1, 3, 5, 7, 8, 10, 12) THEN 31
            WHEN MONTH(DateTime) IN (4, 6, 9, 11) THEN 30
            ELSE DATEDIFF(dd, CAST(YEAR(DateTime) AS varchar(4)) + '-02-01', CAST(YEAR(DateTime) AS varchar(4)) + '-03-01')
       END AS 'days in month'
FROM Weather

Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}