MySQL Forums :: General :: CONVERT_TZ time_zone_id reliable?


Advanced Search

CONVERT_TZ time_zone_id reliable?
Posted by: Larry D. Wilson ()
Date: October 14, 2010 12:35PM

I've populated the mysql timezone info from the zoneinfo on the OS on which it's running. NO problems.

I have more of a usage question. We want to store the customer timezone for better reporting and usage, and my preference is always to store by id for performance and file size issues.

So, is it safe to rely on `time_zone`.`Time_zone_id` from the mysql tables? Do the ID's ever change when new timezone info is loaded? Or if we change OSes? Or do we need to create our own mapping table?

Options: ReplyQuote


Subject Written By Posted
CONVERT_TZ time_zone_id reliable? Larry D. Wilson 10/14/2010 12:35PM
Re: CONVERT_TZ time_zone_id reliable? Larry D. Wilson 10/27/2010 09:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.