Formatting to_char(date)

SELECT TO_CHAR(SYSDATE,'dd-mm-yyyy') FROM DUAL;
20-04-2011

SELECT TO_CHAR(SYSDATE,'dd month yyyy') FROM DUAL;
20 april     2011

SELECT TO_CHAR(SYSDATE,'dd MONTH yyyy') FROM DUAL;
20 APRIL     2011

To get rid of those spaces (between Month and Year):

SELECT TO_CHAR(SYSDATE,'dd fmmonth yyyy') FROM DUAL;
20 april 2011

SELECT TO_CHAR(SYSDATE,'dd fmMONTH yyyy') FROM DUAL;
20 APRIL 2011