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 -> Re: date fromat for 9i

Re: date fromat for 9i

From: Jeff Smith <jsmit234>
Date: Wed, 17 Mar 2004 07:29:47 -0500
Message-ID: <c39gbq$s8l1@eccws12.dearborn.ford.com>


Not a good idea to cross post.

You could start by checking

SELECT * FROM NLS_DATABASE_PARAMETERS
and/or
SELECT * FROM NLS_DATABASE_PARAMETERS and see what the NLS_DATE_FORMAT is configured for. I am working with 8i, so if these aren't valid for 9i, sorry.

This is only in sql plus? Are you sure you don't have some column separator (colsep) or some other setting in sql plus screwed up?

Jeff

"George D. Benetos" <gbenet_at_intracom.gr> wrote in message news:c398u2$kud$1_at_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 - 06:29:47 CST

Original text of this message

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