--<\/p>\n
# rm -f \/etc\/localtime\r\n# ln -s \/usr\/share\/zoneinfo\/Asia\/Taipei \/etc\/localtime<\/pre>\n--<\/p>\n
PHP<\/h2>\n
\n
- Timezone conversion in php<\/a><\/li>\n<\/ul>\n
<?php\r\ndate_default_timezone_set('UTC');\r\n$datetime = new DateTime('2019-9-1 8:00:00');\r\necho $datetime->format('Y-m-d H:i:s') . \"\\n\";\r\n$la_time = new DateTimeZone('America\/Anchorage');\r\n$datetime->setTimezone($la_time);\r\necho $datetime->format('Y-m-d H:i:s');<\/pre>\n\u6642\u9593\u52a0\u6e1b<\/p>\n
<?php\r\nini_set('date.timezone','UTC');\r\n$datetime = new DateTime('2019-12-1 8:00:00');\r\necho $datetime->format('Y-m-d H:i:s');\r\n\r\ndate_sub($datetime, date_interval_create_from_date_string('10 days'));\r\necho $datetime->format('Y-m-d H:i:s');<\/pre>\n--<\/p>\n
MySQL<\/h2>\n
\n
- MySQL CONVERT_TZ\uff08\uff09<\/a><\/li>\n
- mysql_tzinfo_to_sql<\/a><\/li>\n<\/ul>\n
# mysql_tzinfo_to_sql \/usr\/share\/zoneinfo\/right | mysql -u root mysql -p<\/pre>\n\u91cd\u555f\u670d\u52d9<\/p>\n
# systemctl restart mariadb.service<\/pre>\n\u8f49\u63db\u6642\u5340<\/p>\n
\n
- How to Convert UTC Date To Local time Zone in MySql Select Query<\/a><\/li>\n<\/ul>\n
SELECT CONVERT_TZ(displaytime,'UTC','Asia\/Taipei');\r\nSELECT CONVERT_TZ(displaytime,'+00:00','+08:00');<\/pre>\n--<\/p>\n
\u65e5\u5149\u7bc0\u7d04<\/h2>\n