Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: A quick question about time

Re: A quick question about time

From: Roman Miroshnichenko <mir_at_udco.cbsd.donetsk.ua>
Date: Thu, 30 Mar 2000 12:05:04 +0300
Message-ID: <8bv5eu$2onm$1@usb.dipt.donetsk.ua>


You must use function TO_DATE
for exampe:
Insert into TableX
VALUES (TO_DATE('30/03/2000 12:06:13', 'dd/MM/yyyy HH24:Mi:ss'));

Best regards!
Roman Received on Thu Mar 30 2000 - 03:05:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US