Convert the VARCHAR2 type to date.
311152Feb 25 2013 — edited Mar 26 2013Hi,
I want to convert the Strings to date format which is stored in VARCHAR2 column.
PROGRESS_DATE ( VARCHAR2)
============
2012/10/10
10/12/2012
I want to convert using to_date function, but i am getting error.
Query:
select to_char(progress_date,'dd/mm/yyyy') from Progress_record where id = 100100000285;
Error:
====
ORA-01722: invalid number
Please suggest A SOLUTION