SQL

check timezone of mysql database

SELECT @@system_time_zone as tz; 

set database timezone mysql

SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';
SET @@global.time_zone = '+00:00';

check mysql timezone

#The query below returns the timezone of the current session.

select timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00'));

set database timezone mysql

# SET ON /etc/my.cnf

default-time-zone='+00:00'

mysql timezone

[mysqld]
default-time-zone = "+00:00"