Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: syntax
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