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

What is pl/sql language case sensitive?

1132

Why we use stored procedure instead of query?

1002

Explain alias in sql?

1054

Does truncate table reset auto increment?

1002

What is native sql query?

1028

How can we link a sql database to an existing android app?

1036

Is natural join same as inner join?

948

what are the different type of sql's statements ? : Sql dba

927

What is sql and how does it work?

1182

Can sql function call stored procedure?

1028

Explain some predefined exceptions.

1043

What is not equal in sql?

1132

Can we update views in sql?

942

What are all the ddl commands?

1187

Is sql harder than python?

1110