Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Sybase to Oracle date conversion

Sybase to Oracle date conversion

From: Emtek pc <ahc2_at_execpc.com>
Date: Wed, 12 Aug 1998 08:57:17 -0700
Message-ID: <6qs7d5$o9g@newsops.execpc.com>


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. Received on Wed Aug 12 1998 - 10:57:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US