I thing the suggestion was to set the timezone to GMT.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Jeffrey C. Dege" <jdege_at_jdege.visi.com> wrote in message
news:slrn8hcbbo.hp9.jdege_at_jdege.visi.com...
> On Mon, 08 May 2000 02:00:27 GMT, MyTwoBits <nighr_at_hotmail.com> wrote:
> >If you're on Unix, you need to set the TZ environment variable to the
> >timezone you want for the Oracle account in the file $HOME/.profile.
Each
> >Unix account could be a different local time zone. When you startup
Oracle,
> >it should be in that time zone.
>
> That works fine for getting timestamps into the records, but since the
> timestamps don't have timezone information into them, it makes date
> artithmetic impossible.
>
> In other words, if a process began at 02:45, EDT, and ended at 02:15,
> EST, the elapsed time would be 0:30, but because the timezone info isn't
> included in the timestamps, a a simple subtraction returns -0:30.
>
> --
> Feles mala! Cur cista non uteris? Stramentum novum in ea posui.
Received on Mon May 08 2000 - 00:00:00 CDT
