setenv NLS_DATE_FORMAT
"dd-mon-yyyy hh24:mi:ss"
$ sqlplus scott/tiger
SQL*Plus: Release 8.1.5.0.0 - Production on Mon Jun 26 06:56:33 2000
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.5.1.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.1.0 - Production
scott@ORACLE8I> select sysdate from dual;
SYSDATE
--------------------
26-jun-2000 06:56:37
scott@ORACLE8I>
from:http://www.itpub.net/thread-473341-1-1.html
http://asktom.oracle.com/tkyte/Misc/NLSDateFormat.html