Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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.Received on Mon Feb 02 1998 - 00:00:00 CST