mySQL: Calculate TIMEDIFF with mysql version < 4.1 - Calculate the time difference between two dates with the result is in seconds.

Quick Search:

mySQL: Calculate TIMEDIFF with mysql version < 4.1

Jump to:

Category: >> mySQL >> Calculate TIMEDIFF with mysql version < 4.1

<< last

next >>

Snippet Name: Calculate TIMEDIFF with mysql version < 4.1

Description: Calculate the time difference between two dates with the result is in seconds.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

// TIMEDIFF BETWEEN two dates AND the result IS IN seconds
SELECT ((TO_DAYS(DATE_FORMAT('1997-10-04 22:23:00', '%Y-%m-%d')) * 86400) +
        TIME_TO_SEC(DATE_FORMAT('1997-10-04 22:24:00', '%T')))
- ((TO_DAYS(DATE_FORMAT('1997-10-04 22:24:00', '%Y-%m-%d')) * 86400) +
        TIME_TO_SEC(DATE_FORMAT('1997-10-04 22:22:00', '%T')))