14,983
edits
PHP and MySQL syntax: Difference between revisions
Jump to navigation
Jump to search
m
→time difference of two time values
(→timer) |
|||
| Line 139: | Line 139: | ||
* 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 */ {{exclaim}} time difference between two {{kbd | key=<nowiki>DATETIME</nowiki>}} values | * 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 | ||
==== timer ==== | |||
Recording the time elapsed after the sql query was executed. | |||
<pre> | |||
SELECT @timer := CURRENT_TIMESTAMP(); | |||
SELECT SLEEP(2); //sleep 2 seconds for testing purpose | |||
SELECT 'custom message' AS 'action', CURRENT_TIMESTAMP() AS 'end time', @timer AS 'start time', TIMEDIFF(CURRENT_TIMESTAMP(), @timer) AS 'time elapsed'; | |||
</pre> | |||
=== date interval === | === date interval === | ||