/SQL/Check mysql timezone

Check mysql timezone

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 vote263 views1 answer
Commit transaction sql
SQL
1 vote264 views1 answer
Does insert into overwrite sql
SQL
-1 vote236 views1 answer
How to format tables in sqlplus
SQL
0 vote277 views1 answer
Mssql disable foreign key constraint
SQL
1 vote258 views2 answers
Sql left characters
SQL
0 vote265 views1 answer
Sql clear table
SQL
0 vote264 views1 answer
Call rest api from postgresql
SQL
2 votes261 views2 answers
Mysql on duplicate key ignore
SQL
0 vote272 views4 answers
How to connect form to database
SQL
0 vote281 views1 answer
Display all node label neo4j
SQL

Share