External Tables and date formats

From: Matt <mathewbutler_at_yahoo.com>
Date: 3 Feb 2004 00:30:24 -0800
Message-ID: <19f48a45.0402030030.63e205ec@posting.google.com>

I am having problems getting the external table functionality in 9i to work correctly with dates (maybe it just doesn't work as I expect?).

Using the following syntax and a reject limit of zero:

col1 char(10) date_format date mask "RRYY-MM-DD",
col2 date(10) mask "RRYY-MM-DD",
col3 char(10) date_format date mask "YYYY-MM-DD",
col4 date(10) mask "YYYY-MM-DD",

I can't seem to get records such as:

200-12-01

to cause a failure. Instead the record gets loaded as 2000-12-01

Can anyone kindly point me in the direction of the syntax I am looking for (metalink and the doco have been no help so far).

Thanks in advance. Received on Tue Feb 03 2004 - 02:30:24 CST