Re: Unable to Load Data into Database

I have a similar situation in Sybase System 10.

SS10 bcp output for datetime format comes out like

Jan 22 1998 10:00:00:000AM

Assuming you're using sqlldr, in the control file for date files try the following:

field name in table to be loaded is "DATEFIELD"

DATEFIELD "TO_DATE(substr(:DATEFIELD,1,20)||substr(:DATEFIELD,24),'MON DD YYYY HH:MI:SSAM')" This effectively removes the milliseconds from the bcp out.

Hope this helps, and if you come up with an elegant solution for embedded new lines in SQL*Load, please let me know! (winxxniw_at_aol.com) Received on Sat Jan 24 1998 - 00:00:00 CST