Boyd, Todd M. wrote:
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.
http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html
You can convert back and forth
-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2008 6:23 AM
To: mysql@lists.mysql.com
Subject: RE: what is the proper way to store timezone information?
Boyd, Todd M. wrote:
When recording this information, do I store the full name
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
All,
I will be recording timezone information based on user input using the
time zone names from mysql.time_zone_name - names
like 'America/Los_Angeles'.
When recording this information, do I store the full name or just
the 'time_zone_id' which is present in mysql.time_zone_name ?
thanks
Per
-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 5:17 AM
To: mysql@lists.mysql.com
Subject: what is the proper way to store timezone information?
All,
I will be recording timezone information based on user input using the
time zone names