Skip to content

Instantly share code, notes, and snippets.

@manjufy

manjufy/mysql-timestamp.sql

Created May 15, 2018 03:23
Show Gist options
  • Save manjufy/8dbe51ea14885f542198fef768beb56d to your computer and use it in GitHub Desktop.
Save manjufy/8dbe51ea14885f542198fef768beb56d to your computer and use it in GitHub Desktop.
Download ZIP
Timestamp
Raw
mysql-timestamp.sql
-- How to tell what my timezone offset of the database is
select @@global.time_zone, @@session.time_zone;
select timediff( now(), utc_timestamp());
@manjufy
Copy link
Author

manjufy commented May 15, 2018

https://javorszky.co.uk/2016/06/06/today-i-learned-about-mysql-and-timezones/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment