NLS_DATE_FORMAT=DD-MON-YYYYNLS_LANG=AMERICAN_AMERICA.AL32UTF8
C:\>sqlplus / as sysdbaSQL> select sysdate from dual;SYSDATE--------------------28-MAR-2009