Home Forums SQL Server 2012 SQL Server 2012 - T-SQL No of Months between two dates in YYYYMM format RE: No of Months between two dates in YYYYMM format

  • July 16, 2015 at 9:23 am

    #1813026

    Jeff Moden (7/16/2015)

    I still want to know what someone considers to be a month. DATEDIFF(mm,'20150630','20150701') will say that a month has passed when only 1 day will have passed. What is the definition of a "month" for this case? 30 Days? 30.2 days? 4 Weeks? 5-4-4? What?

    I guess the definition of a month for this case is very simple as the OP is not dealing with days, just a year-month combination.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2