Explore our sites

Stack Exchange
tour help
Take the tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

We are having a shared hosting plan and they are saying that do provide MYSQL Timezone support in a shared hosting plan. I can create timezone related tables in our database and populate them with required data(data from from our local MYSQL Timezone related tables. How to view the code syntax for MySQL "CONVERT_TZ" function?

Thanks Arun

share|improve this question
 
Answer already exist in stackoverflow.com here –  GeoStoneMarten 18 hours ago
add comment

1 Answer

up vote 0 down vote

In order to timezone support to be around, the hosting company should have executed this:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql ...

The mysql_tzinfo_to_sql utility should load the time zones. Please make sure the host company has done this. If they can't or won't,

  • you could into Amazon EC2, you could have full access to MySQL and can run it yourself
  • Find a willing hosting company

BTW Here is the MySQL Documentation for CONVERT_TZ : http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_convert-tz

share|improve this answer
 
Thanks for your response. It seems that the hosting provider is not willing to do that. I have referred this link and asked them. Before purchasing the plan their support team confirmed me about their support for MySQL Timezone. I know the CONVERT_TZ date/time execution syntax. I have asked for something like "SHOW FUNCTION CODE" to view how this CONVERT_TZ function is implemented in MySQL Server and try to adopt and create as a user defined function so that I may execute the function against the Timezone related tables adopted from MySQL and created by me in our local database. Thanks-Arun –  pranivi Jun 18 at 2:32
 
If my answer was really helpful, please mark it accepted by clicking the checkmark. –  RolandoMySQLDBA Jun 18 at 3:13
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.