select to_char(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 / john bershan

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

Answer Posted / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

Is This Answer Correct ?

1 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is natural join same as inner join?

940

What are triggers and its uses?

1046

What is meant by truncate in sql?

1068

What is procedure in pl sql?

1046

what are the differences between char and nchar? : Sql dba

1115

What is the requirement of self-join?

1132

What are the operators in sql?

1027

Is sql open source?

973

What are joins in sql?

1044

What is a procedure in pl sql?

1211

How do I clear the screen in sql plus?

1041

When you have to use a default "rollback to" savepoint of plvlog?

1191

How is sql used in oracle?

1005

Is sql a scripting language?

1010

what is an index? : Sql dba

995