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 format on SQL*Loader import

Date format on SQL*Loader import

From: Andy Kent <andykent.bristol1095_at_virgin.net>
Date: 13 Oct 2005 08:16:04 -0700
Message-ID: <1129216563.961160.320640@z14g2000cwz.googlegroups.com>


I'm trying to import some data that's been exported from Access. The data contains dates like "2/11/2004", i.e. it's possible that the DD or the MM may not have both digits present. I'm using a date mask of "DD/MM/YYYY" but this seems to be causing SQL*Loader to barf. How do I tell it about the variation in the lengths?

Or is a better way to do this?

Thanks

Andy Received on Thu Oct 13 2005 - 10:16:04 CDT

Original text of this message

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