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

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1034

how many groups of data types? : Sql dba

971

How to rename a table?

956

How many types of cursors are available in pl/sql?

1042

what is bdb (berkeleydb)? : Sql dba

974

What operating systems are supported by oracle sql developer?

903

Define overloaded procedure?

1014

What are the different dml commands in sql?

1085

How do we use distinct statement? What is its use?

976

Is sql dba a good career? : SQL DBA

939

Is mariadb nosql?

989

How to add a column ‘salary’ to a table employee_details?

953

What is difference between pl and sql?

992

What is a pragma statement?

1201

What is sql deadlock?

1048