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

Explain architecture of sql server notification services?

985

What is a .db file?

926

What found sql?

894

What is flag in sql?

981

What is the file extension for sql database?

936

What does data normalization mean?

897

How do you break a loop in pl sql?

985

How can we avoid duplicating records in a query?

922

what is data manipulation language? : Sql dba

946

Can sql developer connect to db2?

985

Why is there a need for sqlcode and sqlerrm variables?

996

What is sql prepared statement?

937

How many commands are there in sql?

971

What are few of the schema objects that are created using PL/SQL?

968

What is the difference between a primary key and a unique key?

998