xxxxxxxxxx
sudo mysql #login mysql then execute
SELECT @@global.time_zone AS GlobalTimeZone, @@session.time_zone AS SessionTimeZone;
xxxxxxxxxx
SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';
SET @@global.time_zone = '+00:00';
xxxxxxxxxx
#The query below returns the timezone of the current session.
select timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00'));
xxxxxxxxxx
SELECT @@global.time_zone AS GlobalTimeZone, @@session.time_zone AS SessionTimeZone;