setting timezone for MySQL using PHPMyAdmin

user_1575059 0
Viewed 90502

Currently whenever a user creates a new account, I have a Creation_date column that has datatype timestamp. Currently this timestamp reads 3 hours ahead of EST (if it's 5PM in Boston it reads 8PM). Is there a way to change the timezone to EST? What timezone is it set to currently?

phpmyadmin mysql
5 Answers

SET GLOBAL time_zone = timezone;

user_13082360

This is a COMPLETE example, for Argentina

SET GLOBAL time_zone = "-03:00";

you just need to change the "-03:00" for your timezone and run that command like a simple query, even in PhpMyAdmin.

user_102207400
Related