Re: Date format help

Martyn,

Thanks for your suggestion. I did try :

        SELECT sysdate from dual;

and it's truncated to a9 also.
The V$NLS_PARAMETERS view shows the new format, which is more than 9 characters (e.g 'MM-DD-YYYY').

As I'm not an Oracle expert yet, I even do not have an idea what else to check.

Jane

Martyn Cavett wrote:

> Jane -
>
> have you checked for explicit format masks set for the date field(s)
> in
> your select statement e.g. a9 in 'column' SQL*Plus commands that run
> before
> the select?
>
> As a test try: select sysdate from dual; and this should comform to
> the
> NLS_DATE_FORMAT specified.
>
> Martyn.
> caveet_at_globalnet.co.uk
>
> Jane Mikityanskaya <jane_at_hnrc.tufts.edu> wrote in article
> <339F144C.EC934043_at_hnrc.tufts.edu>...
> > Hello,
> >
> > 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?
> >
> > Best regards,
> > Jane
> >
> >
Received on Thu Jun 12 1997 - 00:00:00 CDT