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
15856 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 is sql*loader and what is it used for?

1158

How do you exit in sql?

1114

How do you go back in sql?

993

how to convert numeric values to character strings? : Sql dba

1112

What is a full join?

996

What is indexes?

1063

How do you optimize a query?

1010

What is the use of procedures?

976

How to move files from one directory to another in pl sql?

1197

Is left join faster than inner join?

1129

How can you fetch common records from two tables?

1063

What is the difference between a database and a relational database?

1108

how to get @@error and @@rowcount at the same time? : Sql dba

1033

Why partition by is used in sql?

1046

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1110