If you do not want to change the NLS_DATE_FORMAT for the database you can change it only for your session.

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY';

SELECT SYSDATE FROM DUAL;

SYSDATE
--------------
23-FEB-2001

Sanjay