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

  • April 27, 2011 at 2:40 am

    #1316412

    DECLARE @dtDate DATETIME

    SET @dtDate = '2011/02/28'

    SELECT @dtDate= dateadd(mm,datediff(mm,0,@dtDate),0)

    SELECT datediff(dd,@dtDate,dateadd(mm,1,@dtDate))

    Regards,
    Mitesh OSwal
    +918698619998