Re: SQLLOAD question

From: Binh Do <binhdo_at_onramp.net>
Date: 1998/02/08
Message-ID: <6bm187$sca$1_at_news.onramp.net>#1/1


if the milliseconds are not important then use something like perl or sed to take it out. Afterwards, in the *.ctl file, use:

sybasedate date "MM DD YYYY HH:MI:SSAM"

You can also use any other date mask.

Bhavesh Gosar wrote in message <6bdkds$ne1$2_at_engnews2.Eng.Sun.COM>...
>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
>
>
>
Received on Sun Feb 08 1998 - 00:00:00 CET

Original text of this message