Community Q&A:
Mysql time zone tables
Apparently the timezone tables are not loaded in the mysql databases that I have created.
If I run the query SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York'); I get a result of NULL.
Can the time zone tables be loaded?
If I run the query SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York'); I get a result of NULL.
Can the time zone tables be loaded?
ANSWERS
|
0
|
Hello 2050design, The timezone info is not on any of the MYSQL installations on any server by default. It is not something that can be enabled on a per user basis as it requires root access in MySQL and will affect everyone. If, however, you are looking to set a timezone in a program, you can set that in your php.ini file under the setting date.timezone For example, to set the php timezone for East Coast in the US the setting would be date.timezone="America/New_York" We have information on changing your local php settings here: http://www.webhostinghub.com/help/learn/website/how-to/update-local-php-settings You can also find a list of the supported timezones for php here http://php.net/manual/en/timezones.php Best Regards, Scott M |
Want to share this Question?
Tweet
Help Center Login
Related Articles
It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
