Re: SQLLOAD question

On 6 Feb 1998 00:10:36 GMT, gosar_at_bhavesh.eng.sun.com (Bhavesh Gosar) wrote:

>I have a data file (data output from Sybase "BCP"
>utility) which has a date format as
>"May 6 1994 5:11:54:190PM"
>
>How do i put this data into the date field in Oracle
>database using the SQLLoad Utility...??
>
>TIA,
>Bhavesh Gosar
>

The easiest way is to load the data into a varchar2 field, then do the conversion in SQL*PLus using the appropriate date mask. Keep in mind that any bad dates will fail the conversion once in Oracle.

Michael Received on Fri Feb 06 1998 - 00:00:00 CET