snowal raj

snowal raj

  • NA
  • 166
  • 39.4k

How to get difference in two datetime in mysql

Feb 28 2017 7:49 AM
Hai,
 
I need to get difference of two datetime, and that diff value is set in next column.
like 
 
 
 
 Date Duration
 28-02-2017 17:46:00 
 28-02-2017 17:47:00 00:01:00
 28-02-2017 17:49:00 00:02:00
 28-02-2017 17:55:00 00:06:00
Total
 00:09:00

Answers (5)