/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 vote188 views1 answer
Deleted table in sql trigger
SQL
0 vote200 views1 answer
Joins vs includes
SQL
0 vote205 views1 answer
Create table with float datatype in sql server
SQL
0 vote192 views2 answers
Sqlite unix timestamp
SQL
0 vote236 views1 answer
Creating sqeuence in oracle database
SQL
0 vote250 views1 answer
Get foreign table names mysql
SQL
0 vote262 views1 answer
Oracle job session
SQL
3 votes202 views3 answers
Mysql select table names
SQL
1 vote188 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
1 vote196 views1 answer
Oracle sql create or replace view
SQL

Share