Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT SYSDATE(), SLEEP(2), SYSDATE()

mysql> mysql> SELECT SYSDATE(), SLEEP(2), SYSDATE(); +---------------------+----------+---------------------+ | SYSDATE()           | SLEEP(2) | SYSDATE()           | +---------------------+----------+---------------------+ | 2007-07-22 19:46:15 |        0 | 2007-07-22 19:46:17 | +---------------------+----------+---------------------+ 1 row in set (2.02 sec) mysql>