Re: Date format help

From: Jane Mikityanskaya <jane_at_hnrc.tufts.edu>
Date: 1997/06/13
Message-ID: <33A1A748.35F7BAE7@hnrc.tufts.edu>#1/1

Thanks to all for the suggestions!!
Shame on me! I should have known this before:

DATEWIDTH parameter has been set to default 9 characters. That's why inspite of NLS_DATE_FORMAT settings the date has been truncated during displaying.

Regards, Jane

Douglas Dunnigan wrote:

> Jane Mikityanskaya <jane_at_hnrc.tufts.edu> wrote in article
> <339F144C.EC934043_at_hnrc.tufts.edu>...
> > I can't get any luck in setting up a non-default date format.
> > After submitting a statement
> >
> > SQL> alter session set nls_date_format = 'MM-DD-YYYY';
> >
> > NLS_DATE_FORMAT parameter has changed to a new format.
> > BUT browsing the actual data with the SELECT statement truncates it
up
> > to 9 characters.
> > Can someone told where I am wrong?
>
Received on Fri Jun 13 1997 - 00:00:00 CDT