Gee, I hope none of my users will be affected... mysql> select distinct up_value from user_properties where up_property = "timecorrection"; +--------------------------+ | up_value | +--------------------------+ | Offset|0 | | 08:00 | | System|480 | | ZoneInfo|480|Asia/Taipei | +--------------------------+