Use this syntax if you want to convert String into Date Format :
SELECT TO_CHAR (TO_DATE(’02#07′,’MM/YY’), ‘MM/YY’) FROM DUAL;
Source : http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements004.htm#SQLRF00212
Use this syntax if you want to convert String into Date Format :
SELECT TO_CHAR (TO_DATE(’02#07′,’MM/YY’), ‘MM/YY’) FROM DUAL;
Source : http://docs.oracle.com/cd/E11882_01/server.112/e26088/sql_elements004.htm#SQLRF00212