/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

7 votes116 views6 answers
Nth highest salary in sql
SQL
0 vote165 views1 answer
Get last inserted primary key
SQL
14 votes114 views2 answers
Oracle add column with default value
SQL
10 votes120 views2 answers
Mysql alter add foreign key
SQL
5 votes129 views4 answers
Change auto increment mysql
SQL
0 vote124 views1 answer
Search starting with mysql
SQL
0 vote110 views1 answer
Docker export psql sql
SQL
1 vote142 views2 answers
Changes not showing on website server odoo
SQL
0 vote122 views1 answer
Describe in sqlite3
SQL
0 vote110 views1 answer
Sqlite explain plan
SQL

Share