How to convert a date to char in Oracle? Give one example.

Oracle - Interview Questions

The to_char() function is used to convert date to character. You can also specify the format in which you want output.

SELECT to_char ( to_date ('12-12-2012', 'DD-MM-YYYY') , 'YYYY-MM-DD') FROM dual;

Or,

SELECT to_char ( to_date ('12-12-2012', 'DD-MM-YYYY') , 'DD-MM-YYYY') FROM dual;