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 -> date format for 9i

date format for 9i

From: George D. Benetos <gbenet_at_intracom.gr>
Date: Wed, 17 Mar 2004 12:33:08 +0200
Message-ID: <c398v0$kue$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:33:08 CST

Original text of this message

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