Answers for "mysql default timezone"

set database timezone mysql

SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';
SET @@global.time_zone = '+00:00';

Posted by: Guest on December-18-2020

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

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

Code answers related to "mysql default timezone"