Mysql time zone tables

Asked by:
2050design / 5 Points
Time:
2013-01-03 1:09 am EST
Category:
Databases
Hits:
499
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?

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

ScottM
Staff
13,037 Points
2013-01-03 9:52 am EST
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

To submit a comment on this answer, please first login.

Want to share this Question?

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!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.