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
16101 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 error ora-01000: maximum open cursors exceeded

1214

What can you do with pl sql?

1146

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1021

How much does sql cost?

1068

What is the purpose of using pl/sql?

1189

What is the default isolation level in sql server? : Transact sql

1089

Is pl sql and postgresql same?

1183

What is the difference between the conventional and direct path loads? : aql loader

1476

What is partition in sql query?

1047

What are the advantages of sql?

1101

What does inner join mean?

1265

Are stored procedures faster than queries?

991

what is a trigger in mysql? : Sql dba

1216

What are the different sql commands?

1130

What is the command used to fetch first 5 characters of the string?

1467