Hi All,
Is it possible to store the timezone with datetime data type in mysql or any
other approach available to achieve this in mysql.
Looking for your help.
Thanks,
Manoj
MySQL doesn't support timezones (I think Postgres does). I usually
just store dates as Greenwich Mean Time and store the time zone hours
offset in a separate field.
Brent Baisley
On Tue, Jul 28, 2009 at 7:59 AM, Manoj Singhmanojsingh2...@gmail.com wrote:
Hi All,
Is it possible to store the
Agreed. Store as UTC. You can always convert to the needed timezone during
query or during display. See MySQL's CONVERT_TZ() function.
On Tue, Jul 28, 2009 at 8:29 AM, Brent Baisley brentt...@gmail.com wrote:
MySQL doesn't support timezones (I think Postgres does). I usually
just store dates
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
program.
Does MySQL store TimeZone and DayLight Saving Time changes ?
Or does it have a way to find it once you have a field whose type is
timestamp ?
Thanks a lot in advance for your help,
Patrick, Mariella
-
Before posting