81
87
+---------------------+----------+---------------------+
82
88
| SYSDATE() | SLEEP(2) | SYSDATE() |
84
90
| 2011-02-20 20:15:09 | 0 | 2011-02-20 20:15:11 |
85
91
+---------------------+----------+---------------------+
87
93
When using replication, the binary log will include SET TIMESTAMP entries so that a database can be restored from the binary log. In doing this, values from NOW will be adjusted to the same times as when the original SQL statements were executed. SYSDATE entries will be unaffected by SET TIMESTAMP entries.