DateTime Question

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


[Quoted] I have a table with two fields:

EventDateTime Date not null
[Quoted] 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 CEST

Original text of this message