Re: Sybase to Oracle date conversion

From: <prochak_at_my-dejanews.com>
Date: Thu, 13 Aug 1998 12:23:58 GMT
Message-ID: <6qulsu$j6m$1@nnrp1.dejanews.com>

In article <6qs7d5$o9g_at_newsops.execpc.com>, ahc2_at_execpc.com wrote:
> The Sybase BCP program unloads dates in the format Mon dd yyyy
> hh12:mi:ss:000AM or PM . How can I get the Sql*Loader to recognize the
> AM or PM to load the date properly. If I use the substr function every
> date loads as an AM date.
>

Is there a reason why you do not use the AM formatting option of the TO_DATE function? you shouldn't trim off the AM/PM. It looks like you need:

fieldname DATE 'MON DD YYYY hh12:mi:ss:000AM'

in your control file. Or is that what you are already doing? I must be misreading your question because this seems too simple.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 13 1998 - 07:23:58 CDT