Boyd, Todd M. wrote: >> >> When recording this information, do I store the full name or just >> the 'time_zone_id' which is present in mysql.time_zone_name ? > > This is entirely a matter of choice. It's like asking if you should > store formatting when you insert phone numbers into a database--is it > easier for you to parse back if you do so? If yes, then store the > formatting. If no/probably not/I don't need to parse it, then just > store it without.
My concern is whether the time_zone_id is a fixed reference of the timezone. If the id might (for whatever reason) change in the future, I'd have to store the timezone name. /Per Jessen, Zürich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
