Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date fromat for 9i
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