database timezone difference

S

Sam Dela Cruz

--=_alternative 0069C49A882570F3_=
Content-Type: text/plain; charset="US-ASCII"

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
--=_alternative 0069C49A882570F3_=--
 
E

Eric Hodel

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

Robert Klemme

Eric said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top