select to_date('Column_Name','dd-mon-yyyy') from table

wirte a query to filter improper date format follwing table?
date
20-apr
22-may-2010
26-jun-2010
feb-2009

i want the output

date
22-may-2010
26-jun-2010

Question Posted / praveen

6 Answers
15839 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / praveen

select to_date('Column_Name','dd-mon-yyyy') from table_name;

Is This Answer Correct ?

23 Yes

15 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do rank () and dense_rank () differ?

1046

What do you mean by field in sql?

1077

What are the types of triggers in sql?

1089

What are the different datatypes available in PL/SQL?

1085

What are the parameter modes supported by pl/sql?

1109

What are the different types of joins in sql?

1791

what is 'mysqlshow'? : Sql dba

1027

Is sql injection illegal?

1025

How many types of primary keys are there?

1040

Which is better varchar or nvarchar?

997

Can we connect to postgresql using sql developer?

1009

How do I edit a trigger in sql developer?

995

Can we use delete in merge statement?

1039

Can we join two tables without common column?

1005

What are schema-level triggers?

1102