Example
Select 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'
Select 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'
