WHAT TIME IS IT?
This post started with a simple question: “Does the function NOW() get executed every time a row is examined?” According to the manual, “Functions that return the current date or time each are evaluated only once per query …. multiple references to a function such as NOW() … produce the same result. …. (However,) as of MySQL 5.0.12, SYSDATE() returns the time (the row is) executes. “
- CURDATE() returns the current date.
- CURTIME() returns the current time.
- UTC_DATE() returns the current UTC date.
- UTC_TIME() …