uday wrote:
> 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
FROM_TZ within a DECODE should work.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Tue Sep 19 2006 - 09:44:53 CDT
