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
15767 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 are the sql aggregate functions?

1109

what is commit? : Sql dba

1063

What is pls integer?

1019

what are the nonstandard string types? : Sql dba

1124

what is myisam? : Sql dba

1060

Does sql between include endpoints?

989

Can triggers stop a dml statement from executing on a table?

1068

What is difference between nchar and nvarchar?

1010

Can a procedure in a package be overloaded?

1030

When should I use nosql database?

988

How long does it take to learn pl sql?

1046

what are all the common sql function? : Sql dba

1048

What is the difference between truncate and drop statements?

1169

what is the syntax for using sql_variant_property? : Transact sql

1026

How to set up sql*plus output format in oracle?

1021