What time zone do MySQL TIMESTAMP ON UPDATE columns use?

Question

Does it use the server time zone or UNIX_TIMESTAMP (UTC)?

And how do I get the current time in PHP, in the same time zone as the MySQL TIMESTAMP columns?

Answer 1

Depends on your MySQL configuration variables, see MySQL Server Time Zone Support .