Re: sqlldr & date/time question

On 09 Mar 2002 22:34:08 GMT, ktyson9426_at_aol.com (KTyson9426) wrote:

>Hello.... And thank you in adnvace for anyones help
>
>I want to use sqlldr to load the date/time into the same date field in my
>table. I can get the date in there ok, and I can get the time in with the use
>of a different field, but I can't find anything that tells me how to do get the
>date/time in the same field. I've found how to do this with an 'insert'
>statement, but I need to use sqlldr..... Can anyone tell me how to format the
>*.ctl file? Currently I have;
>
>load data
>infile *
>append into table vmstat
>fields terminated by ","
>(ddate, ttime, vmstat)
>begindata
>30-Jan-02, 0122, 'data'

Just specify an appropiate mask

Please check out
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76955/ch05.htm#20660

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Mar 10 2002 - 05:37:22 CST