DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Steve has posted 12 posts at DZone. View Full User Profile

Days In Month In SQL Server (without User Functions)

02.18.2009
| 10990 views |
  • submit to reddit
        
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
...