Home » RDBMS Server » Server Utilities » Date Format mm/dd/yy importing to Oracle
Date Format mm/dd/yy importing to Oracle [message #70172] Wed, 24 April 2002 11:51 Go to next message
Dennis Carlson
Messages: 1
Registered: April 2002
Junior Member
I'm trying to import a fix length file with date format of mm/dd/yy into Oracle with SQL Loader. i.e.

DUE_DATE POSITION(71:80) DATE "mm/dd/yy",

How to I format in the control file? HELP!

Report message to a moderator

Re: Date Format mm/dd/yy importing to Oracle [message #70174 is a reply to message #70172] Wed, 24 April 2002 20:14 Go to previous message
Sujit Mahapatra
Messages: 19
Registered: March 2002
Junior Member
Hey,
you have the format already written over there:

DUE_DATE POSITION(71:80) DATE "mm/dd/yy",

As I see the field width it takes in the datafile
is 10. Where as the format it appears is "dd/mm/yy"
which is 8 characters. No problem. The date will be
taken in properly wherever it appears in the 10
characters width slot (as long as the data format
is as dd/mm/yy.

Any problems? - Revert back.

Cheers,
Sujit

Report message to a moderator

Previous Topic: exporting a partitioned table?
Next Topic: SQL Loader Import
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 10:28:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.