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

what are different types of keys in sql?

1215

Does sql profiler affect performance?

1045

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1223

What are different types of triggers?

1177

What is exit statement?

1059

What is scope of pl sql developer in future?

1067

What are the constraints available in sql?

1084

What is a full join sql?

1102

Can we use ddl commands in pl sql?

1227

How do I sort a table in sql?

1080

Why use triggers in sql?

1011

What is index example?

1043

What is server name sql?

1202

What is a sql profiler?

1063

What do you understand by exception handling in pl/sql?

1086