I am using new_time to convert US EDT to GMT. Currently there is a
difference of 5 hours between EDT and GMT; but Oracle function shows
difference of 4 hours. It was 4 hours before last month day light time
saving went in effect in US. It is still 4 hour difference instead of
5. I used this function to write day light time saving independent
code, but alas function does not work correctly. Can someone point any
flaws in my reasoning.

I am doing this test in Oracle 10.2.0.4 on HP UNIX 11i. I tried in
Oracle 11.1.0.7.4 as well.

On Dec 10, 9:25*pm, zigzagdna <zigzag... (AT) yahoo (DOT) com> wrote:
I found that new_time is not day light time aware. I am looking for
some way to find difference in GMT and my time zone which is EDT or
EST depending when day light goes in effect. I sfollowing day light
aware:

select extract(timezone_hour from systimestamp) from dual;

and returns 5 today. Will it return me 4 in March or so when new day
light goes in effect.

Prem

Prem ...

# select extract(timezone_hour from systimestamp) from dual;

.... and returns *5 today. Will it return me 4 in March or so when new
day light goes in effect.

Well of course one possibility is actually reading the relevant and
free Oracle documentation for the release you are running.