/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

5 votes212 views1 answer
Sql use database
SQL
1 vote230 views1 answer
Oracle plan hash value
SQL
0 vote208 views1 answer
Mariadb mysql root access denied
SQL
2 votes198 views1 answer
Plsql left() function
SQL
1 vote212 views1 answer
Update substring in mysql
SQL
12 votes185 views5 answers
Sql merge
SQL
51 votes305 views6 answers
Change column name sql
SQL
1 vote221 views2 answers
Oracle leftmost characters
SQL
0 vote208 views1 answer
Opensuse status MySQL
SQL
0 vote191 views1 answer
Oracle sql count occurrences of value in column
SQL

Share