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

From: Rylandda <custserv_at_bodine-assembly.com>
Date: 1998/02/02
Message-ID: <6b4i1q$luu_at_usenet41.supernews.com>#1/1

[Quoted] [Quoted] We are interested on knowing how to convert a string character with a format [Quoted] [Quoted] 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? Received on Mon Feb 02 1998 - 00:00:00 CET

This message: [ Message body ]
Next message: L120bj: "Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle date."
Previous message: Greg Van Holland: "ODBC Memory Allocation Error"
Next in thread: L120bj: "Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle date."
Reply: L120bj: "Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle date."
Reply: L120bj: "Re: Converting "MM/DD/YYYY" in an inported file to a valid Oracle date."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message