/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

4 votes175 views4 answers
Sqlite describe table
SQL
4 votes143 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
3 votes162 views3 answers
Docker create postgresql database
SQL
-1 vote194 views1 answer
Mysql order by on condition
SQL
1 vote201 views1 answer
Mariadb get column names from table
SQL
0 vote177 views1 answer
Sql server select value large text
SQL
0 vote185 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote175 views1 answer
Sql delimiter to columns
SQL
3 votes189 views1 answer
Stpop start psql server
SQL
1 vote133 views1 answer
File /etc/init.d/mysql not exists
SQL

Share