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 format help

Re: Date format help

From: Jane Mikityanskaya <jane_at_hnrc.tufts.edu>
Date: 1997/06/13
Message-ID: <33A1767D.4F8644DE@hnrc.tufts.edu>#1/1

Steve Dover wrote:

> Jane Mikityanskaya wrote:
> >
> > 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
>
> The problem is that somewhere in STANDARD the implicit width
> of the column is 9 characters.
>
> If you do
> Select sysdate "EXTRA_WIDE_COLUMN" from dual ;
>
> This works.
>
> I'd consider it a Y2K related bug :-)
>
> Cheers

    So, I tried :

   SQLWKS> alter session set nls_date_format='DD-MM-YYYY'; Statement processed.
SQLWKS> Select sysdate "EXTRA_WIDE_COLUMN" from dual ; EXTRA_WID



13-06-199
1 row selected.

Is it because of Friday, 13th?? - I don't think so.

Jane Received on Fri Jun 13 1997 - 00:00:00 CDT

Original text of this message

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