Re: sqlplus does not display time portion from a date column

From: Michel Cadot <micadot2removethat_at_free.fr>
Date: Thu, 30 Oct 2003 23:01:50 +0100
Message-ID: <3fa18a34$0$250$626a54ce@news.free.fr>

"Ken Denny" <ken_at_kendenny.com> a écrit dans le message de news:Xns942476CF4D99Akendenny_at_216.77.188.17...
> dsmcd <dsmcd_at_stopspamdormouse.net> wrote in news:E1bob.151$Bi3.26527
> @news.uswest.net:
>
> > Hello...
> >
> > Sqlplus and Sqlplusw do not display the time part of a date
> > column, I just get the dd-MM-yy.
> >
> > 817 on Win2k. Any suggestions?
> >
> > Thx,
> > D.
>
> alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS';
>
> You can put in in your login file so it happens automatically whenever you
> bring up sqlplus.
>
> --
> Ken Denny
> http://www.kendenny.com/

You can also create a value NLS_DATE_FORMAT and set it to this format in the keys HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME* of the Windows registry. So this format is available to all tools and not only SQL*Plus.

Michel Cadot Received on Thu Oct 30 2003 - 16:01:50 CST