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

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/