Re: to_date in oracle 9i with time zone

Thank you Vladimir for the information. I tried to use time zone information as follows-

SELECT TO_TIMESTAMP_TZ('26-OCT-2003, 02:00:00 PST', 'DD-MON-YYYY HH24:MI:SS TZR') from dual;

works fine.

With daylight saving time zone it shows me error messageSELECT  TO_TIMESTAMP_TZ('26-OCT-2003, 02:00:00 PDT', 'DD-MON-YYYY HH24:MI:SS TZR') from dual;

Shows me following-
-01882: timezone region not found

So, timestamp does not understand "daylight saving" time zone.

Harris M.
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<bc51o9$e94$1_at_babylon.agtel.net>...
> "harris" <harris_m_at_yahoo.com> wrote in message
> news:af968c64.0306061234.5cd0b2a1_at_posting.google.com...
> > I am using Oracle 9i. Oracle documentation says 9i supports "time
> > zone" information. I am getting date/time information from a text
> > file, which I want to insert into database table.
> >
> > Question-
> >
> > Anyone knows how to save "time zone" information into the "date" type
> > column?
> >
>
> I doubt it, as this is not possible. You need TIMESTAMP WITH TIME ZONE,
> not DATE, you need to use TO_TIMESTAMP_TZ(), which will recognize
> your format string, and you need to store these timestamps in a TIMESTAMP
> WITH TIME ZONE column. DATEs are still unaware of time zones, and will
> never be.
Received on Thu Jun 12 2003 - 16:06:03 CDT