/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

0 vote142 views1 answer
Copying query result to excel
SQL
1 vote142 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
7 votes131 views6 answers
Reset identity column in sql server
SQL
2 votes177 views2 answers
Mysql search for column name in all tables
SQL
0 vote180 views1 answer
Sql pivot table
SQL
0 vote134 views1 answer
How to move a columns location in mysql
SQL
0 vote135 views1 answer
Sql server bool select
SQL
2 votes278 views1 answer
Set auto increment from 1
SQL
1 vote144 views2 answers
How to check if sql query is correct online
SQL
7 votes136 views6 answers
Nth highest salary in sql
SQL

Share