/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 vote123 views1 answer
Postgres get database encoding
SQL
1 vote104 views1 answer
Oracle difference between two dates in years
SQL
0 vote99 views1 answer
Psql datestyle
SQL
1 vote99 views3 answers
How to truncate foreign key constraint table
SQL
0 vote109 views1 answer
Oracle sql add column auto generated value
SQL
2 votes98 views1 answer
Oracle calculated column
SQL
0 vote100 views1 answer
Mariadb maximum left join
SQL
0 vote101 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
1 vote101 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote89 views1 answer
How to create an SQL save method in ruby
SQL

Share