Hi,
Why dont use this
If we want to change the NLS_DATE_FORMAT AND SEE


ALTER SESSION
SET NLS_DATE_FORMAT = 'YYYY MM DD HH24:MI:SS'
Oracle7 uses the new default date format:


SELECT TO_CHAR(SYSDATE) Today
FROM DUAL
TODAY
-------------------
1993 08 12 14:25:56

Thanks
lnr