/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

7 votes231 views2 answers
Phpmyadmin change password
SQL
0 vote201 views1 answer
What is the use of index in mysql table
SQL
0 vote197 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote203 views1 answer
Load utilities in sql server
SQL
1 vote217 views2 answers
Check if word is in column sql
SQL
5 votes243 views3 answers
Sql limit offset
SQL
0 vote212 views1 answer
Get a list of tables and the primary key
SQL
0 vote205 views2 answers
Oracle create tablespace autoextend
SQL
1 vote211 views1 answer
Second last highest id in sql
SQL
1 vote211 views1 answer
Oracle undo usage per session
SQL

Share