@H_403_2@
+--------------+-------------------+
| id | timezone |
+--------------+-------------------+
| 1 | 'Europe/Helsinki' |
| 2 | 'Europe/Paris' |
+--------------+-------------------+
最佳答案
使用CONVERT_TZ：
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_convert-tz@H_403_2@
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_convert-tz@H_403_2@
@H_403_2@
SELECT * FROM users WHERE hour(CONVERT_TZ(now(),server_tz,`timezone`))=16