在用户时区中显示MySQL日期时间

Question

MySQL datetimes created using now() are stored as UTC.

Client side timezone is detected using JavaScript and returned as "Europe/London".

What is the best way to select the datetime from MySQL and display the created time in the users local time?

PHP and Node are both used with MySQL.

Answer 1

You can use MySQL CONVERT_TZ function

SELECT CONVERT_TZ(NOW(), 'UTC', 'Europe/London')