select * from testdate where to_date(column1,'dd-mon-yyyy')=to

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 / pulakesh

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

Answer Posted / pulakesh

select * from testdate
where to_date(column1,'dd-mon-yyyy')=to_date(column1,'dd-
mon-yyyy') and length(column1)>8

Is This Answer Correct ?

8 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What will you get by the cursor attribute sql%notfound?

1074

what are the limitations of identity column? : Transact sql

1108

Is full outer join same as cross join?

969

What is auto increment feature in sql?

1122

What are the types of records?

988

What is full form of rtm?

1008

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1134

Explain how exception handling is done in advance pl/sql?

999

Explain the difference between triggers and constraints?

975

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

What are the parts of a basic sql query?

967

Which data type is a composite type?

988

State few characteristics of pl/sql?

971

What is normalization in sql?

1011

How to download oracle sql developer?

1106