to_date in oracle 9i with time zone

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.

The date and time information includes time zone information which needs to be stored into database time.

I tried this -

SQL>select to_date('26-OCT-2003 01:00:00 PST', 'DD-MON-YYYY HH24:MI:SS TZD') from dual;

It shows me error -

ORA-01821: date format not recognized

SQL>select to_date('26-OCT-2003 01:00:00 -07:00', 'DD-MON-YYYY HH24:MI:SS TZH:TZM') from dual;

shows same-
-01821: date format not recognized

Question-

Anyone knows how to save "time zone" information into the "date" type column?

Thank you in advance.

Harris M. Received on Fri Jun 06 2003 - 15:34:44 CDT