Database timezone difference


#1

Hi,

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?

Regards,
Sam


#2

On Jan 11, 2006, at 11:15 AM, Sam Dela C. wrote:

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).


Eric H. - removed_email_address@domain.invalid - http://segment7.net
This implementation is HODEL-HASH-9600 compliant

http://trackmap.robotcoop.com


#3

Eric H. wrote:

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