Does anybody really know what time it is?
Posted by Sheeri Cabral on Oct 9, 2008
This is a post about SYSDATE() and NOW() and CURRENT_TIMESTAMP() functions in MySQL.
Firstly, note is that of these three, only CURRENT_TIMESTAMP() is part of the SQL Standard. NOW() happens to be an alias for CURRENT_TIMESTAMP() in MySQL.
Secondly, note that replication does not work well with non-deterministic functions. And “hey, what time is it?” is non-deterministic. Ask it twice, with a second apart between asking, and both times you get different results (with at least second precision).
You can start to see the problem here….but there’s more…. Read the rest of this entry . . .
