Mysql time zone question _ MySQL

Mysql time zone problem bitsCN.com

Mysql time zone problems

During data processing, the data exported by mongo is CET (green) time,

After mysql is imported directly, the time is not converted to + 8. There are two convenient conversion methods:

1. select convert_tz (import_start, '+ 00:00', '+ 8:00') from import_ods_log;

Convert the + 0 time zone to the + 8 time zone

2. set mysql time_zone to + 8, then the query time field will automatically add 8 hours.

The first type is relatively flexible, and the first type is recommended.

BitsCN.com