"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.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Tue Jun 10 2003 - 11:41:09 CDT
