/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 votes98 views1 answer
Postgresql change value in column
SQL
6 votes110 views1 answer
What is where clause in sql
SQL
0 vote112 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
-1 vote115 views1 answer
Mysql coalesce
SQL
1 vote109 views3 answers
Get all tables postgres
SQL
0 vote112 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
-1 vote115 views1 answer
MYSQL stored procedure select from
SQL
0 vote99 views1 answer
Trim sql oracle
SQL
0 vote112 views1 answer
Sql server select top 2 of each group
SQL
0 vote102 views1 answer
INSERT INTO table using OpenQuery
SQL

Share