There aren't any timestamps in Oracle 8i. There is a data/time type and it
does not have a time zone component. One can use sysdate as a "timestamp"
but it is just a date time.
Jim
"Gary Gapinski" <glg_at_apk.net> wrote in message
news:3C06EE0F.DA7772C4_at_apk.net...
> You are likely on an earlier version of Oracle than 9i. It took them a
> couple of decades, but they finally got timestamps right in 9i.
>
> I had the misfortune to find that Oracle 8.1.5 (haven't tested it yet on
> later 8.1 versions) appears to corrupt dates by shifting them on
> delivery via JDBC.
>
> I ended up (wrongly or not) forcing the default timezone to UTC prior to
> JDBC accesses in order to coerce Oracle to deliver correct (unshifted)
> timestamps.
Received on Thu Nov 29 2001 - 21:27:28 CST
