/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

2 votes359 views1 answer
Codeigniter print last sql query
SQL
1 vote356 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote315 views1 answer
Postgres create database if not exists
SQL
0 vote325 views1 answer
Oracle archivemode
SQL
1 vote347 views1 answer
Mysql query bulk insert
SQL
0 vote320 views1 answer
Grant owner postgresql
SQL
0 vote330 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
1 vote332 views1 answer
Nested if in mysql
SQL
0 vote335 views1 answer
Oracle sql winter time change
SQL
0 vote312 views1 answer
Mariadb list tables
SQL

Share