DateTime Question
From: Phillip X. Fei <pfei_at_palasys.com>
Date: 2000/06/14
Message-ID: <3947A017.2BFB64FE_at_palasys.com>#1/1
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