SELECT SYSDATE(), SLEEP(2), SYSDATE(); : SYSDATE « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. 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>








14.42.SYSDATE
14.42.1.SYSDATE() returns the current date and time.
14.42.2.SELECT SYSDATE(), SLEEP(2), SYSDATE();