Now
suggest changeSELECT Now();
Shows the current server date and time.
UPDATE `footable` SET mydatefield = Now();
This will update the field mydatefield
with current server date and time in server’s configured timezone, e.g.
'2016-07-21 12:00:00'
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents