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.
>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?
>
>
>
>
>
>
>
>
>
You could use something along the lines of
DATE_FIELD POSITION(1:10) CHAR TO_DATE(:DATE_FIELD,'MM/DD/YYYY')
This will, however, mean that you cannot use SQL*LOADER in direct path mode
HTH
Rob
Received on Mon Feb 02 1998 - 00:00:00 CST