tsunamilx
5/16/2017 - 4:23 AM

msyql-current-timezone.sql

-- This by default outputs "System, System", which is not useful.
SELECT @@global.time_zone, @@session.time_zone;

-- This outputs the time diff between current timezone and UTC.
-- Example: 08:00:00
SELECT TIMEDIFF(NOW(), CONVERT_TZ(NOW(), @@session.time_zone, '+00:00'));