Answers for "mysql date with timezone get"

SQL
0

check mysql timezone

#The query below returns the timezone of the current session.

select timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00'));
Posted by: Guest on June-27-2021
1

mysql datetime with timezone offset

INSERT INTO table_name  CONVERT_TZ(SUBSTR('2011-10-04 12:58:36 -0600',1,19),'+00:00',SUBSTR('2011-10-04 12:58:36 -0600',20));
Posted by: Guest on May-05-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language