Re: to_date in oracle 9i with time zone

There is no point getting emotional, which often happens when don't know or can not find information.

I am looking for answer to very specific problem. I did looked into documentation from Oracle before posting question here.

Check this page-

http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96540/sql_elements4a.htm#48515

Search for TZD or PDT

Besides this Oracle documentation talks about setting variables such as - NLS_DATE_FORMAT, which does not address my problem - which is given any date and time with "daylight saving" information, save and retrieve it with "daylight saving" information.

I would appriciate if any answer to "Daylight saving into Oracle 9i". If Oracle 9i does not really support it as it says in advertizments, there are always "way around", which people have used in Oracle 8i.

Harris M.  

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<vehusembotb446_at_corp.supernews.com>...
> "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?
Received on Sat Jun 14 2003 - 21:51:51 CDT