Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Calculating Duration Using DATETIME Start and End Dates (SQL Spackle) RE: Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

  • January 16, 2014 at 7:42 am

    #1680659

    Oliver Gugolz (1/16/2014)

    Here is my simple method to format the output to a more readable format:

    CAST(GETDATE() - @StartDT AS TIME(2)) AS Duration

    But that only displays the fractional hours portion of the difference. You still lose the days converted to hours that Jeff's method preserves.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn