|
Re: Date Format mm/dd/yy importing to Oracle [message #70174 is a reply to message #70172] |
Wed, 24 April 2002 20:14 |
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
|
|
|