RSS
Home
|
Link Us
|
Contact
Categories
-- All --
Perl
PHP
MySQL
Windows
JavaScript
HTML
Apache
CVS
Linux
SEO
Perl (9)
PHP (35)
MySQL (5)
Windows (7)
JavaScript (5)
HTML (6)
Apache (6)
CVS (4)
Linux (13)
SEO (11)
The registration is temporarily disabled.
However you can post your comments without registration.
Authentication
Username:
Password:
Register
|
Lost password
-->
Calculate TIMEDIFF with mysql version < 4.1
Home
»
MySQL
»
Calculate TIMEDIFF with mysql version < 4.1
Date: 2006-08-15
Calculate TIMEDIFF with mysql version < 4.1
Download
|
Printer Friendly
Add to Google
Add to Del.icio.us
Add to Digg
Add to Technorati
Add to Yahoo!
Add to Blinklist
Add to Furl
Add to reddit
// 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')))
Comments
No comments yet.
Post a comment
Your Name
Your Email
(won't be published)
Site
(e.g. http://)
*
Title
*
Comment
*
Required fields.
Copyright © 2005-2010
Execution time: 0.14466
hosted by
1and1