/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 votes300 views2 answers
Postgres change owner of schema
SQL
0 vote282 views1 answer
Oracle show running job
SQL
0 vote295 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
6 votes337 views3 answers
Check if string contains substring sql
SQL
4 votes294 views3 answers
Check if two date ranges overlap sql server
SQL
2 votes277 views1 answer
Mariadb select multiple rows into one column
SQL
1 vote283 views1 answer
Xampp import sql file command line
SQL
0 vote280 views1 answer
Add SuperUser MySQL
SQL
0 vote278 views1 answer
Default value false mysql
SQL
2 votes325 views3 answers
Xampp mysql database not starting
SQL

Share