Take the 2-minute 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.

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 Dec 15 '13 at 8:55

1 Answer 1

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 '13 at 2:32
    
If my answer was really helpful, please mark it accepted by clicking the checkmark. –  RolandoMySQLDBA Jun 18 '13 at 3:13

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.