Quick Search:
 
 mySQL: Calculate TIMEDIFF with mysql version < 4.1 Jump to:  
Category: >> mySQL >> Calculate TIMEDIFF with mysql version < 4.1  

<< lastnext >>

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')))
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org