/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

3 votes190 views2 answers
Oracle grants
SQL
0 vote206 views2 answers
Sql stored procedure for access frontend
SQL
0 vote251 views1 answer
Selecting specific day in colum sql
SQL
0 vote259 views1 answer
Sqlite display data in separated columns
SQL
0 vote219 views1 answer
Select place default lat long
SQL
3 votes208 views2 answers
Sql end of month
SQL
0 vote153 views1 answer
Bigquery information_schema schema all columns
SQL
17 votes229 views2 answers
T_sql contains
SQL
0 vote207 views1 answer
Start stop mysql linux
SQL
0 vote201 views1 answer
Sql commands in android
SQL

Share