user07695 Member

Comments

  • I'm having the same issue. I tried combining DATEDIFF and TIMEDIFF like: DATEDIFF(col1,col2)*24*60 + TIME_TO_SEC(TIMEDIFF(col1,col2))*60 but it still isn't working with dates that are less than 24 hours difference, but fall on different calendar days. i.e 10/09/2017 23:00:00 and 10/10/2017 03:00:00. This should give an…
    in Beastmode - Duration (mins) between 2 Datetime Columns Comment by user07695 October 2017
Default Avatar