MySQL时区转换

select lsz.skill_name  as '技能组'
,ses.start_time as '北京时间'
,lsz.time_zone as '时区'
,CONVERT_TZ(ses.start_time, '+08:00', concat(replace(case when lsz.time_zone='UTC' then 'UTC+0' else lsz.time_zone  end,'UTC',''),':00')) '转化后日期时间'


, DATE_FORMAT(CONVERT_TZ(ses.start_time, '+08:00', concat(replace(case when lsz.time_zone='UTC' then 'UTC+0' else lsz.time_zone  end,'UTC',''),':00')) , '%Y-%m-%d') '转化后日期'


,ses.session_id as '会话ID'

from lc_session ses 
left join lc_sys_skillgroup  lsz on ses.SKILL_GROUP  = lsz.skill_id  


where ses.brand_id = 'cooler-master' and ses.start_time >='2024-01-08 00:00:00'