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






  1. MySQL Tutorial
  2. Date Time Functions
  3. NOW
mysql>
mysql> SELECT NOW(), SLEEP(2), NOW();
+---------------------+----------+---------------------+
| NOW()               | SLEEP(2) | NOW()               |
+---------------------+----------+---------------------+
| 2007-07-22 19:46:13 |        0 | 2007-07-22 19:46:13 |
+---------------------+----------+---------------------+
1 row in set (2.02 sec)

mysql>








14.32.NOW
14.32.1.Getting the Current Date and Time
14.32.2.Multiple references to a function such as NOW() within a single query always produce the same result
14.32.3.SELECT NOW(), SLEEP(2), NOW();