Re: Loading dates with nullif clause

Kevan Forest <kevan.forest_at_uni.edu> wrote in article <374ED86B.3C0D494_at_uni.edu>...
: I am trying to load a file that has dates in the format of MMDDYY.
Some
: of the date fields have '000000' in them rather than a valid date.
In
: this case I want to load nulls to the field.
<<skipped>>
YR_PACKAGE_DATE position(238:243)
 "decode(:yr_package_date, '000000', null, to_date(:yr_package_date, 'MMDDYY'))"

-- 
 Alexander I.Doroshko, aid_at_grant.kharkov.ua
 * Bank "Grant", Kharkov, Ukraine