/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 vote191 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote199 views1 answer
Install ms sql server management studio
SQL
4 votes212 views1 answer
W3schools create table
SQL
2 votes160 views1 answer
Sql float to int
SQL
3 votes215 views1 answer
Postgresql today - 1 year
SQL
0 vote203 views1 answer
How to put is null in where in clause
SQL
6 votes216 views2 answers
Mysql interval 1 day
SQL
0 vote205 views1 answer
Which MySQL data type to use for storing boolean values
SQL
3 votes195 views1 answer
Sql timestamp to date
SQL
1 vote203 views1 answer
Stop mysql server mac
SQL

Share