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

Home -> Community -> Usenet -> c.d.o.server -> date fromat for 9i

date fromat for 9i

From: George D. Benetos <gbenet_at_intracom.gr>
Date: Wed, 17 Mar 2004 12:32:38 +0200
Message-ID: <c398u2$kud$1@newsserv.intranet.gr>


I get the following result from sql plus

'yyyy-mm-dd hh24:mi:ss.0'

instead of

'yyyy-mm-dd hh24:mi:ss'

when I try to retrieve a culumn DATE .
The code is the same , only change from 8i to 9i .

Any ideas ?

thanx ..... Received on Wed Mar 17 2004 - 04:32:38 CST

Original text of this message

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