MySQL Forums
Forum List  »  General

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

Written By
CONVERT_TZ time_zone_id reliable?
October 14, 2010 12:35PM

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.