Can MySQL convert a stored UTC time to local timezone?
For those unable to configure the mysql environment (e.g. due to lack of SUPER access) to use human-friendly timezone names like "America/Denver" or "GMT" you can also use the function with numeric offsets like this:
CONVERT_TZ(date,'+00:00','-07:00')
select convert_tz(now(),@@session.time_zone,'+03:00')For get the time only use:
time(convert_tz(now(),@@session.time_zone,'+03:00'))