| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Date format help
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
Is it because of Friday, 13th?? - I don't think so.
Jane Received on Fri Jun 13 1997 - 00:00:00 CDT
 |
 |