Skip to content

Instantly share code, notes, and snippets.

@covard

covard/mysql_convert_time_zone.md

Created June 14, 2022 19:21
Show Gist options
  • Save covard/76540e1199f12879380c838eae0c3029 to your computer and use it in GitHub Desktop.
Save covard/76540e1199f12879380c838eae0c3029 to your computer and use it in GitHub Desktop.
Download ZIP
A reminder on how to convert time in mysql, i.e. a job starts at 10pm mountain time what time is that UTC?
Raw
mysql_convert_time_zone.md

MySQL

Convert Time Zone

select convert_tz('2022-06-14 22:00:00', 'US/Mountain', 'UTC');

2022-06-15 05:00:00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment