Re: Daylight savings and timezones

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.