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

Written by Knilluz on 20 April 2011 at 13:26