Re: to_date in oracle 9i with time zone

"harris" <harris_m_at_yahoo.com> wrote in message news:af968c64.0306121306.40e28789_at_posting.google.com...
> 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 message-
> SELECT TO_TIMESTAMP_TZ('26-OCT-2003, 02:00:00 PDT', 'DD-MON-YYYY
> HH24:MI:SS TZR') from dual;
>
> Shows me following-
> ORA-01882: timezone region not found
>
> So, timestamp does not understand "daylight saving" time zone.
>
> Harris M.

And you did verify that in the docs, before making ur bald statement?

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address