Re: time zone related problem

I have a given time say "12/12/2006 12:00" in "EST" and i need to convert this time corresponding to timezone "Hongkong"

when i use
SELECT * FROM V$TIMEZONE_NAMES WHERE TZNAME LIKE 'Hongkong%'

it gives me 4 rows out of which three are invalid timezone according to oracle 10.2.0.1.0

the 4th one which works gives me 12/12/2006 11:00:00 AM for the query SELECT NEW_TIME (TO_DATE ('2006/12/12 12:00', 'yyyy/mm/dd HH24:MI'), 'EST', 'CST') FROM dual

but actul should be 13-DEC-2006 01:00

i think this is more clear.

please help

thanks in advance Received on Mon Sep 18 2006 - 23:19:25 CDT