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 -> Re: DateTime Question

Re: DateTime Question

From: Yann Cauchard <yann.cauchard_at_spcconsultants.com>
Date: 2000/06/14
Message-ID: <8i87ka$p0r$1@news4.isdnet.net>#1/1

You have to specify the format for your entry : Insert into MyEvent values (TO_DATE('06/14/00 2000, 15:45:04','MM/DD/RR, HH24:MI:SS')...

Phillip X. Fei a écrit dans le message <3947A017.2BFB64FE_at_palasys.com>...
>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