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

What is the left table in sql?

915

Explain commit, rollback and savepoint.

933

Is oracle sql free?

928

how can we know the count/number of elements of an array? : Sql dba

1007

How can I change database name in sql?

1003

How do you update a sql procedure?

974

what is bcp? When does it used? : Sql dba

935

Can we perform dml on view?

976

Which is faster union or join?

903

Do we need commit after truncate?

1034

What is the use of & in pl sql?

988

How long does it take to learn pl sql?

1001

Can we delete column in sql?

1025

what is 'mysqladmin' in mysql? : Sql dba

974

What does pragma mean?

975