Re: Column format

You CAN'T change the properties of the column itself. You CAN alter NLS_DATE_FORMAT so the default display format changes. This can be done either by alter session commands, or by setting the registry variable nls_date_format in HKLM\software\oracle.

Hth,

Sybrand Bakker, Oracle DBA

Maxx <mace74_at_hotmail.com> wrote in message news:8bf7tv$n45$1_at_news.ihug.co.nz...
> Does anyone know if it is possible to modify date column format so that
> instead of ddmmyy it shows another format, other than by altering it in
the
> SELECT clause or creating a view? Actually changing the properties of the
> column itself, rather than just how it is viewed?
> MAXX
>
>
Received on Fri Mar 24 2000 - 02:15:16 CST