Re: date format question for sqlldr

hello,

the datatype sysdate do not recognize ms, but with 9i there are some new datatypes like timestamp and with it, you have the option to work with ms!

[Quoted] i don´t think you can change the datatype for date-data in the controlfile. why do you will change it?

regards,
thorsten häs

On Wed, 17 Dec 2003 22:00:58 GMT, Scott Mattes <Scott_at_TheMattesFamily.ws> wrote:

> yhkumars_at_yahoo.com (sujit) wrote in
> 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.

-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/