Extracting date from varchar
977650Feb 25 2013 — edited May 9 2013Hi,
I am working in an environment where user inserts the dates manually. so he may insert the date in 'dd/mm/yyyy' format or 'yyyy/dd/mm' format or any other like this.
Can you tell me how can i extract date format from this table. I am giving a test table as example here :-
Create table test(created_on varchar2(20));
insert into test values('01/12/2010');
insert into test values('11/02/2010');
insert into test values('2012/02/10'); How can i extract date in format 'DD/MM/YYYY' ?
I am using oracle 11g
Thnx in advance