/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 vote355 views1 answer
Utiliser sql ligne de commande
SQL
0 vote354 views3 answers
Between keyword sql
SQL
12 votes385 views10 answers
Google
SQL
23 votes405 views5 answers
Sql substring
SQL
0 vote358 views2 answers
How to get json data mysql
SQL
0 vote358 views1 answer
C# datetime to sql server datetime
SQL
1 vote337 views1 answer
Mysqli connect
SQL
27 votes431 views3 answers
Mysql delete row
SQL
14 votes366 views3 answers
Alter foreign key
SQL
0 vote699 views1 answer
Power bi connect to postgresql
SQL

Share