Re: Date format help

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 Received on Thu Jun 12 1997 - 00:00:00 CDT