Home Forums SQL Server 2005 SQL Server 2005 Compact Edition total time difference between more than two dates RE: total time difference between more than two dates

  • July 18, 2013 at 7:37 pm

    #1633821

    this works for me:

    SET @StartDate = (Select '2013-07-19 12:20:07.097')

    Set @EndDate = (SELECT '2013-07-19 15:02:38.000')

    SET @RESULT = (SELECT 'Starts in: ' + STR(FLOOR(CAST(@newDate-@RunDate AS FLOAT)),1) + ' days '

    + convert(varchar,datepart(hour,@EndDate-@StartDate)) + ' hrs '

    + convert(varchar,datepart(minute,@EndDate-@StartDate)) + ' mins')

    Result is: 'Starts in: 0 days 2 hrs 42 mins'