Oracle’s new_time function is buggy?
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. 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.