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

Home -> Community -> Usenet -> c.d.o.server -> Re: syntax

Re: syntax

From: Venki Ramachandran <venkir_at_wacsinc.com>
Date: Mon, 23 Jul 2001 10:07:49 -0700
Message-ID: <3B5C59E4.C4752053@wacsinc.com>

You need to convert the value using the to_date function and giving the proper format string. In your case use 'mm/dd/rr hh24:mi:ss'. It should work.

CyAndrew wrote:

> PLEASE HELP ME TO FIND WHERE IS MISTAKE
> in first (DATE type) COLUMN.
>
> insert into stroj1 values ('01/01/99 10:10:10', 4,4,4,4);
Received on Mon Jul 23 2001 - 12:07:49 CDT

Original text of this message

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