Re: Date format in SQL*plus limited to 9 characters??!!

Alan Long wrote:
>
> I'm using Oracle 8 SQL*plus on NT4
>
> A simple "select sysdate from dual" correctly produces:
>
> SYSDATE
> ---------
> 09-jan-01
>
> I then change the date format with "alter session set nls_date_format =
> 'dd-mon-yyyy'"
>
> "Select sysdate from dual" produces:
>
> SYSDATE
> ---------
> 09-jan-20
>
> The last 2 characters have been truncated.
>
> I then try a column format command "column mydate format a14"
>
> "select sysdate mydate from dual" results in:
>
> MYDATE
> --------------
> 09-jan-20
>
> The column header has changed to 14 characters but the date is still limited
> to 9 characters.
>
> I've used other versions of SQL*plus and have no problem...... I can display
> date/times like '20-Dec_2000 19:57' . It looks like some system default is
> constraining my current version of SQL*plus.
>
> Any idea how I fix this? It must be trivial!
>
> --
> Regards,
> Alan

The setting can be made on both the server (as per your alter session) and on the client - check your registry - you may need to change it there as well

HTH
COnnor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"