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 -> date mask in SQL*Loader

date mask in SQL*Loader

From: web guy <web-guy01XXSPAMMXX_at_comcast.net>
Date: Fri, 09 Feb 2007 11:17:33 -0500
Message-ID: <_JKdnT3Oro23A1HYnZ2dnUVZ_hCdnZ2d@comcast.com>


I'm using SQL*Loader with a delimited file from Excel. I have a date field that the users are 'supposed' to populate with a format of 'mmddyyyy', and I simply do a to_date(:date_field,'MMDDRRRR') in the lod script and all is well.

However, very often I get dates in the file with a format of 'M/D/YYYY' or 'MM/DD/YYYY', and rather then reject that record during load, I would of course like to load it anyway.

Any suggestions on how to do this?

Tim Received on Fri Feb 09 2007 - 10:17:33 CST

Original text of this message

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