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'