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

Home -> Community -> Usenet -> c.d.o.misc -> Re: sql*loader and Date

Re: sql*loader and Date

From: Robert Klemme <bob.news_at_gmx.net>
Date: Fri, 19 May 2006 09:52:22 +0200
Message-ID: <4d5bpmF17r0opU2@individual.net>


swaxolez wrote:
> I tried removing the (10) and also changed the DD/MM/YY to DD/MM/YYYY
> and it still reports the error:
>
> Record 1: Rejected - Error on table HYDDATA, column Cr_DATE.
> ORA-01847: day of month must be between 1 and last day of month

Well then, *do* you have a date like 31/04/2006?

        robert Received on Fri May 19 2006 - 02:52:22 CDT

Original text of this message

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