Home Forums Article Discussions Article Discussions by Author Discuss content posted by Harsha Majety Function to get number of days in month RE: Function to get number of days in month

  • June 13, 2011 at 6:50 am

    #1337717

    And why not:

    Declare @day DATETIME

    Set @day='2011-02-15'

    select datediff(day,dateadd(d,1-day(@day),@day),dateadd(m,1,dateadd(d,1-day(@day),@day)))

    🙂