(wrong string) ’s new_time function is buggy?

From: zigzagdna <zigzagdna_at_yahoo.com>
Date: Fri, 10 Dec 2010 21:02:22 -0800 (PST)
Message-ID: <9e017a50-699a-4440-8c54-42d4846484cb_at_32g2000yqz.googlegroups.com>

On Dec 10, 9:25 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
> 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.

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 Received on Fri Dec 10 2010 - 23:02:22 CST