14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
→time difference of two time values
m (→timer) |
|||
| Line 138: | Line 138: | ||
=== time difference of two time values === | === time difference of two time values === | ||
* php: using [http://php.net/manual/en/function.mktime.php mktime()] function | * php: using [http://php.net/manual/en/function.mktime.php mktime()] function | ||
* mysql: using [http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_timediff TIMEDIFF()] function ex: SELECT TIMEDIFF('2016:02:01 00:00:00', '2016:01:01 00:00:00'); /* return 744:00:00 */ | * mysql: using [http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_timediff TIMEDIFF()] function ex: SELECT TIMEDIFF('2016:02:01 00:00:00', '2016:01:01 00:00:00'); /* return 744:00:00 */ {{exclaim}} time difference between two {{kbd | key=<nowiki>DATETIME</nowiki>}} values | ||
=== date interval === | === date interval === | ||