Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: total time difference between more than two dates

    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)) +...

    July 18, 2013 at 7:37 pm

    #1633821

Viewing post 1 (of 1 total)