Re: Please Help!
From: Alex J <AlexJent_at_prodigy.net>
Date: 1998/12/24
Message-ID: <75tatf$rnm$1_at_newssvr04-int.news.prodigy.com>#1/1
15-MAR-98 18:35:00 Steven wrote:
------oOOo-( )-oOOo-----
mario.perreault_at_bigfoot.com
Oracle DBA
Date: 1998/12/24
Message-ID: <75tatf$rnm$1_at_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 CET