mysql 时区-时间转换
时区(timezone)转换函数:convert_tz(dt,from_tz,to_tz)
select convert_tz('2008-08-08 12:00:00', '+08:00', '+00:00'); -- 2008-08-0804:00:00 SELECT CONVERT_TZ(CURDATE(), '+08:00', '+00:00')
时区(timezone)转换函数:convert_tz(dt,from_tz,to_tz)
select convert_tz('2008-08-08 12:00:00', '+08:00', '+00:00'); -- 2008-08-0804:00:00 SELECT CONVERT_TZ(CURDATE(), '+08:00', '+00:00')