The following query: SELECT TO_CHAR(DATE '2003-12-23', 'DD-MON-YYYY'); returns a result of '23-DEC-2003'.