view raw
GeoGo GeoGo - 9 months ago 50
MySQL Question

Difference between two dates in MySQL

How to calculate the difference between two dates, in the format

YYYY-MM-DD hh: mm: ss
and to get the result value in seconds or milliseconds?

SELECT TIMEDIFF('2007-12-31 10:02:00','2007-12-30 12:01:01');
-- result: 22:00:59.

SELECT TIMESTAMPDIFF(SECOND,'2007-12-30 12:01:01','2007-12-31 10:02:00'); 
-- result: 79259  the difference in seconds with the time.