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

Is sql database free?

924

What is benefit of creating memory optimized table?

907

Explain the uses of database trigger.

1054

What is rownum and rowid?

983

What are the advantages of normalization?

1038

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1114

What is the advantage of index in sql?

915

What are the subsets of sql?

1037

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4095

Define the select into statement.

993

Why self join is used in sql?

916

how to rename an existing column in a table? : Sql dba

959

How to check if a column is nullable before setting to nullable?

1055

What is a unique key?

1004

What is meant by cursor in sql?

941