Re: date format question for sqlldr

yhkumars_at_yahoo.com (sujit) wrote in
[Quoted] news:a64cf821.0312171340.2e25b553_at_posting.google.com:

> Is it possible to specify milli-seconds as part of the date format for
> a date field in a control file ?
>
> I would like to use a format of the form: "YYYY-MM-DD hh24:mi:ss.ssss"
> where, YYYY: 4-digit year, MM: month, DD: day, hh24: 24-hour, mi:
> minutes, ss: seconds, ssss: milli-seconds.
>

The Oracle date format does NOT recognize anything less than whole seconds. Received on Wed Dec 17 2003 - 23:00:58 CET