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
16112 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

define sql update statement ? : Sql dba

1159

what is cross join? : Sql dba

1054

What is the difference between cross join and natural join?

1070

What is sqlservr exe?

1030

When should I use nosql database?

1061

Why do we use joins in sql?

1012

What is Difference Between Unique and Primary Key Constraints?

1155

Define the select into statement.

1114

how are mysql timestamps seen to a user? : Sql dba

1201

Can one improve the performance of sql*loader? : aql loader

1099

How do I find sql profiler?

992

What is output spooling in sql*plus?

1092

What are the usages of sql?

1104

how to include numeric values in sql statements? : Sql dba

1149

How to run sql functions in pl/sql?

1126