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
15768 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 is dbo in sql?

943

What is the usage of sql functions?

1130

What is implicit cursor in pl sql?

1076

How to use distinct and count in sql query? Explain

1003

how do you control the max size of a heap table? : Sql dba

960

What is the difference among union, minus and intersect?

985

What is sql server and ase?

1008

What are the most important ddl statements in sql?

1090

How can you fetch common records from two tables?

1051

what is the difference between nested subquery and correlated subquery?

1034

How to call a javascript function from pl sql?

1121

what is a trigger? : Sql dba

1016

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1043

What is pivot in sql?

903

What is the basic form of sql query?

927