Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> DateTime Question
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
![]() |
![]() |