select * from employees where length(hire

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

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

Answer Posted / kumar

select * from employees
where
length(hire_date)=length(sysdate)

Is This Answer Correct ?

2 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does sap use sql?

963

How show all rows in sql?

998

How do you explain an index number?

1080

how to install mysql? : Sql dba

1091

What is an exception in PL/SQL? What are the two types of exceptions?

1278

Explain the components of sql?

1044

What is set serveroutput on in pl sql?

1272

What is exception? What are the types of exceptions?

1061

What is a behavioral trigger?

961

how to create a table index in mysql? : Sql dba

1037

What does pl sql developer do?

913

How to rename a column in the output of sql query?

1064

Is sql between inclusive?

1110

What is a full join?

959

How insert into statements in sql?

1057