作者：傻丫头苏婵_596 | 来源：互联网 | 2023-09-13 22:32
时区&＃xff08;timezone&＃xff09;转换函数&＃xff1a;convert_tz(dt,from_tz,to_tz)
select convert_tz(&＃39;2008-08-08 12:00:00&＃39;, &＃39;&＃43;08:00&＃39;, &＃39;&＃43;00:00&＃39;); -- 2008-08-0804:00:00
SELECT CONVERT_TZ(CURDATE(), &＃39;&＃43;08:00&＃39;, &＃39;&＃43;00:00&＃39;)
时区转换也可以通过 date_add, date_sub, timestampadd 来实现。select date_add(&＃39;2008-08-08 12:00:00&＃39;, interval -8 hour); -- 2008-08-08 04:00:00select date_sub(&＃39;2008-08-08 12:00:00&＃39;, interval 8 hour); -- 2008-08-08 04:00:00select timestampadd(hour, -8, &＃39;2008-08-08 12:00:00&＃39;); -- 2008-08-08 04:00:00
京公网安备 11010802041100号