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

Home -> Community -> Usenet -> c.d.o.tools -> DateTime Question

DateTime Question

From: Phillip X. Fei <pfei_at_palasys.com>
Date: 2000/06/14
Message-ID: <3947A017.2BFB64FE@palasys.com>#1/1

I have a table with two fields:

EventDateTime Date not null
EventDesc varchar(500) not null

when I insert a record in either of the following two queries, it gives error.

Insert into MyEvent values ('6/14/00 2000, 15:45:04', 'test');

or:

Insert into MyEvent values (TO_DATE('6/14/00 2000, 15:45:04'), 'test');

What is the correct syntax to insert both date and time into one Date field?

Thanks Received on Wed Jun 14 2000 - 00:00:00 CDT

Original text of this message

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