Re: Timestamp TZR Question

From: <fitzjarrell_at_cox.net>
Date: Mon, 13 Aug 2007 06:24:26 -0700
Message-ID: <1187011466.094014.254320@19g2000hsx.googlegroups.com>

Comments embedded.
On Aug 13, 7:56 am, "Tim Arnold" <timkarn..._at_comcast.net> wrote:
> Greetings,
>
> I'm on O v 9.2.0.8, W2003.
>
> Given a local date, time, and country, is there a way to determine EST/EDT,
> the critical factor here being daylight savings time aware?
>

Yes, I believe there is.

> Don't I need a country to Oracle Time Zone Region table to be able to use
> the correct Oracle TZR?

I would expect having such a table would be a convenience.

>
> And using timestamp w/TZR is daylight savings time aware, correct?
>
> Thanks

Oracle is DST aware, as indicated here:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements2a.htm#51542

You might also want to check here, for working examples of information extractable from a timestamp, and methods to do so:

http://www.psoug.org/reference/timestamp.html

David Fitzjarrell Received on Mon Aug 13 2007 - 08:24:26 CDT