Re: Please Help!

From: Alex J <AlexJent_at_prodigy.net>
Date: 1998/12/24
Message-ID: <75tatf$rnm$1@newssvr04-int.news.prodigy.com>#1/1

You need to fix that stutter Mario.... :-)

    Mario Perreault wrote in message
<368159BE.3D5A1C3F_at_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 Thu Dec 24 1998 - 00:00:00 CST