Answers for "get gmt out from mysql"

how to set global time_zone in mysql

SET GLOBAL time_zone = timezone;

eg: SET GLOBAL time_zone = 'Asia/Kolkata';

Posted by: Guest on December-27-2020

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 "get gmt out from mysql"