Skip to content

Instantly share code, notes, and snippets.

@shafinmahmud

shafinmahmud/mysql-timezone.txt

Created September 28, 2017 17:32
Show Gist options
  • Save shafinmahmud/d2b97ae76f0cd9f2f4539ecada9f3cc2 to your computer and use it in GitHub Desktop.
Save shafinmahmud/d2b97ae76f0cd9f2f4539ecada9f3cc2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql-timezone.txt
-- To see what timezone your MySQL session is using, just execute this:
SELECT @@global.time_zone, @@session.time_zone;
-- If you feel to Change on your specific TimeZone, execute:
SET GLOBAL time_zone = '+6:00';
SET SESSION time_zone = '+6:00';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment