/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 vote108 views1 answer
Sql add calculated column
SQL
4 votes114 views1 answer
Describe table mysql
SQL
-2 votes185 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote99 views1 answer
Events not working db
SQL
9 votes111 views1 answer
Oracle get table schema
SQL
0 vote60 views1 answer
Check sql query executed wp
SQL
1 vote290 views1 answer
Postgres upgrade to superuser
SQL
0 vote57 views1 answer
Kannst du deine finger trainieren
SQL
0 vote109 views1 answer
Mysql where in maintain order
SQL
53 votes267 views6 answers
Sql server alter column
SQL

Share