From: Robert Klemme <bob.news@...>
Date: 2006-01-12T20:13:11+09:00
Subject: Re: database timezone difference

Eric Hodel wrote:
> On Jan 11, 2006, at 11:15 AM, Sam Dela Cruz wrote:
>
>> I'm pulling data from a database in Europe and saving a dataset in
>> North
>> America database.  Included in the data are DateTime information.
>> Because
>> the timezones are different, when I pull the data it gets
>> translated to
>> local timezone.  Locally, in North America, I need to process reports
>> based on dates, and I need to have a report exactly as if it came
>> from European database.  How do I preserve the date in European
>> timezone before
>> being uploaded to North American db?
>
> a) store times in UTC
> b) use a database that has a column type of "timestamp with time
> zone" (Postgres or equivalent).

In Oracle it's called "TIMESTAMP WITH LOCAL TIMEZONE" - values are
converted to the sessions timezone on retrieval.  This is in Oracle 9 and
newer.  Oracle's "Globalization Support Guide" is a good reading on the
matter.

HTH

    robert