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

From: L120bj <l120bj_at_aol.com>
Date: 1998/02/02
Message-ID: <19980202190500.OAA25924@ladder03.news.aol.com>#1/1

>Subject: Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle
>date.
>From: l120bj_at_aol.com (L120bj)
>Date: 2/2/98 6:50PM GMT
>Message-id: <19980202185001.NAA12985_at_ladder02.news.aol.com>
>
>>Subject: Converting "MM/DD/YYYY" in an inported file to a valid Oracle date.
>>From: "Rylandda" <custserv_at_bodine-assembly.com>
>>Date: 2/2/98 1:29PM GMT
>>Message-id: <6b4i1q$luu_at_usenet41.supernews.com>
>>
>>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?

Sorry about my previous message, there is a far simpler means e.g.
DATE_FIELD (1:10) "MM/DD/YYYY" Apologies
Rob Received on Mon Feb 02 1998 - 00:00:00 CST