Home Forums SQL Server 2012 SQL Server 2012 - T-SQL DATEDIFF with days and hours RE: DATEDIFF with days and hours

  • February 18, 2013 at 5:37 am

    #1588796

    To get the hours as a decimal. else its 6 days + 5 hours = 11 days and should be 6 days + .5 hours = 6.5 days.

    Not 100% sure this will work yet.

    Ian Cockcroft
    MCITP BI Specialist