/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

2 votes345 views1 answer
Datefromparts mssql
SQL
0 vote324 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
16 votes289 views4 answers
Sort by sql
SQL
5 votes305 views1 answer
Oracle asynchronous update
SQL
1 vote299 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote309 views1 answer
Wordpress database query change url
SQL
0 vote306 views2 answers
Search stored procedures
SQL
0 vote310 views1 answer
How to create a table based on another table in mysql
SQL
5 votes281 views2 answers
Oracle tables with column name
SQL
0 vote345 views1 answer
Mysql concatenate select results
SQL

Share