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

MySQL TUTORIALS » Date Time Functions » NOW »

Multiple references to a function such as NOW() within a single query always produce the same result


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>