/SQL/Check timezone of mysql database

Check timezone of mysql database

Set database timezone mysql

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

1

Source: stackoverflow.com

Set database timezone mysql

# SET ON /etc/my.cnf

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

1

Source: stackoverflow.com

Check mysql timezone

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

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

0

Check timezone of mysql database

SELECT @@system_time_zone as tz;

0

Similar codes

9 votes362 views5 answers
Sql delete duplicate rows but keep one
SQL
13 votes396 views2 answers
Oracle select into and inner join
SQL
7 votes370 views1 answer
Mysql iif
SQL
0 vote386 views1 answer
How to map sql column to custom names
SQL
0 vote346 views2 answers
Getting customers with no orders sql
SQL
3 votes419 views1 answer
Mysql cli connect with password
SQL
0 vote361 views1 answer
Sql find all different values in column
SQL
0 vote379 views2 answers
Script all indexes in a database
SQL
24 votes360 views4 answers
Postgres remove database
SQL
4 votes360 views1 answer
Oracle error line
SQL

Share