Re: Please Help!

From: Mario Perreault <mario.perreault_at_informission.ca>
Date: Wed, 23 Dec 1998 15:54:56 -0500
Message-ID: <368158A0.2A83DF24@informission.ca>

You must use the "new_time" function to convert GMT time to another...

new_time(x,y,z) : Returns the current date and time for date x in time zone y as it would be in time zone z.

Sample :

SELECT TO_CHAR(NEW_TIME(TO_DATE(‘15-MAR-1998 14:35:00’, ‘DD-MON-YYYY HH24:MI:SS’),‘AST’,‘GMT’) FROM DUAL; NEXT_DAY(‘15-MAR-9

---

15-MAR-98 18:35:00 Steven wrote:

> hi,
>
> May l know what's the function to convert the GMT time
>
> to Singapore's time (Local time).
>
> Thanks
>
> --
> With regards
> Steven
>
> Steven Koh, Internet Software Engineer,
> Mediaworks, Pacific Internet Pte. Ltd.,
> 77 Science Park Drive, 04-09/12
> Cintech III, Singapore Science Park,
> Singapore 118256.
>
> Tel: (65) 7711305;
> Fax: (65) 8728523
> www.mediaworks.com.sg, www.pacific.net.sg

--

        \\\|||///
        /  ^ ^  \
        (  0 0  )

------oOOo-(_)-oOOo-----
mario.perreault_at_bigfoot.com
Oracle DBA Received on Wed Dec 23 1998 - 14:54:56 CST