Home Forums SQL Server 2008 SQL Server 2008 - General Logic to break period of time by month RE: Logic to break period of time by month

  • August 21, 2013 at 11:00 pm

    #1643744

    If you just want the difference between the dates in the two columns

    datediff(mm,col1,col2) + 1 to include the first month

    eg select datediff(mm,'6/27/13','8/11/13') +1

    Cheers

    Jamie

    😎

    We are the pilgrims, master.
    We shall go always, a little further.