Multiple references to a function such as NOW() within a single query always produce the same result : NOW « Date Time Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Date Time Functions
  3. NOW
mysql>
This principle also applies to CURDATE(), CURTIME(), UTC_DATE(), UTC_TIME(), UTC_TIMESTAMP(), and to any of their synonyms.
mysql>
mysql> select now(), now();
+---------------------+---------------------+
| now()               | now()               |
+---------------------+---------------------+
| 2007-07-22 19:46:01 | 2007-07-22 19:46:01 |
+---------------------+---------------------+
1 row in set (0.00 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();