sysdate SELECT SYSDATE FROM DUAL SELECT TO_CHAR( SYSDATE, 'yyyy.MM.dd') c_date FROM DUAL SELECT TO_CHAR ( TO_DATE ( '20091025' || '000001', 'YYYY-MM-DD HH24:MI:SS'), 'yyyy.MM.dd' ) c_date FROM DUAL ORACLE·sql 2009.12.11