Re: date fromat for 9i

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 Mar 2004 10:10:22 -0800
Message-ID: <2687bb95.0403171010.7e6506b0@posting.google.com>

"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 .....

Check the nls_date_format setting for the database along with the other NLS settings in v$nls_parameters.

HTH -- Mark D Powell -- Received on Wed Mar 17 2004 - 12:10:22 CST