/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

18 votes158 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
5 votes90 views1 answer
Copy table from one database to another mysql
SQL
0 vote161 views1 answer
Cannot start database server xampp mac os
SQL
0 vote134 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
5 votes138 views3 answers
Oracle list columns in schema
SQL
0 vote137 views1 answer
Postgresql if else endif
SQL
5 votes142 views1 answer
Oracle nls instance
SQL
4 votes138 views3 answers
Employee name starting with in sql
SQL
3 votes128 views2 answers
Sql add year to date
SQL
0 vote181 views1 answer
Osm2pgsql mac
SQL

Share