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 wrote:
> MySQL doesn't support timezones (I think Postgres does). I usually
> just store dates as Greenwich Mean
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 Singh wrote:
> Hi All,
>
> Is it possible to store the timezone with datetime d
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
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
> -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
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--
> -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
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
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
