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 -> date -field import

date -field import

From: Andreas Lommel <him_lommel_at_t-online.de>
Date: Wed, 10 Nov 1999 10:22:58 GMT
Message-ID: <38294499.7520724@news.btx.dtag.de> 





Hi there, I want to import a date with SQL-Loader. The value is
00.00.0000, which stand for a standard date. 
Then there is a error message ORA-01847
day of month must be between 1 and last day of month 
Cause: The day of the month listed in a date is invalid for the
specified month. The day of the month (DD) must be between 1 and the
number of days in that month. 


What can I do ???

Received on Wed Nov 10 1999 - 04:22:58 CST












Original text of this message













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