/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 vote272 views1 answer
Wordpress database query change url
SQL
0 vote265 views1 answer
Mysql query to select the highest value
SQL
3 votes237 views1 answer
What is having clause
SQL
0 vote249 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
2 votes282 views1 answer
How to select from mssql
SQL
1 vote247 views4 answers
Between vs in sql
SQL
5 votes237 views2 answers
Oracle to_timestamp
SQL
0 vote241 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote285 views1 answer
Bitmap join index
SQL
12 votes256 views5 answers
Sql merge
SQL

Share