To_Char() function Example in oracle 11g

SELECT employee_id, TO_CHAR(hire_date, 'MM/YY') Month_Hired FROM employees WHERE last_name = 'Higgins';

Here employees table contains columns as employee_id and hire_date. We have implemented to_char() function on hire_date column.

You can also use other format as below:-

SELECT last_name, TO_CHAR(hire_date, 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') HIREDATE FROM employees;