Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle date.

Rylandda wrote:

> We are interested on knowing how to convert a string character with a format
> of "MM/DD/YYYY" that is being imported from an external source into a valid
> Oracle date field when running SQL*LOADER. Is there a function or a routine
> we could use in the control file?

LOAD DATAINFILE '........'
INTO TABLE X
(
 column_name DATE "MM/DD/YYYY'
 )

Hope this helps

AMARENDRA
Oracle DBA

--
*****************************************************************
AMARENDRA B NETTEM
Oracle Certified DBA (OCP)
Whittman-Hart Inc.,
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.

Residence:
-----------
5039 N E River Road,
Apt. 1A
NORRIDGE, IL 60656


Ph.No. (708) 583 9870 (H)
       (312) 913 6758 (W)

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************
Opinions are mine and do not necessarily reflect those
of Whittman-hart Inc.