From: l120bj@aol.com (L120bj)
Subject: Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle date.
Date: 1998/02/02
Message-ID: <19980202203401.PAA07628@ladder03.news.aol.com>#1/1
References: <19980202190500.OAA25924@ladder03.news.aol.com>
X-Admin: news@aol.com
Organization: AOL, http://www.aol.co.uk
Newsgroups: comp.databases.oracle.misc



>Subject: Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle
>date.
>From: l120bj@aol.com (L120bj)
>Date: 2/2/98  7:05PM  GMT
>Message-id: <19980202190500.OAA25924@ladder03.news.aol.com>
>
>>Subject: Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle
>>date.
>>From: l120bj@aol.com (L120bj)
>>Date: 2/2/98  6:50PM  GMT
>>Message-id: <19980202185001.NAA12985@ladder02.news.aol.com>
>>
>>>Subject: Converting "MM/DD/YYYY" in an inported file to a valid Oracle
 date.
>>>From: "Rylandda" <custserv@bodine-assembly.com>
>>>Date: 2/2/98  1:29PM  GMT
>>>Message-id: <6b4i1q$luu@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
>
>
>
>
>
>
>

Bad day at the office or what ?  There should, of course, be the word DATE,
before the "MM/DD/YYYY" format.

Surely I can't have got anything else wrong !
  Rob