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

Home -> Community -> Mailing Lists -> Oracle-L -> SQLLoader and RR date format

SQLLoader and RR date format

From: Michael Parry <parrymd_at_yahoo.com>
Date: Wed, 19 Jul 2000 12:25:49 -0700 (PDT)
Message-Id: <10563.112441@fatcity.com>


Hi most knowledgeable ones,

I have an 8.0.5 database with the date format set to DD-MON-RR. I'm trying to load data through sqlloader with date data formatted as RRMMDD (430210 is Feb 10th 1943). The query results return 10-FEB-2043 using to_date(mydate,'DD-MON-YYYY').

Is there a way in sqlloader to load this date in it's current format and have it show in the database as 1943?

Am I missing something?

Data to load: 430210
Ctl code: birthday position(1:6) date 'RRMMDD' Table column: birthday date

Thanks, Mike



Do You Yahoo!?
Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ Received on Wed Jul 19 2000 - 14:25:49 CDT

Original text of this message

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