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 5:51 am

    #1680612

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

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