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

List the various privileges that a user can grant to another user?

1098

Is microsoft sql free?

1142

How many tables can you join in sql?

1010

Which sql statement is used to return only different values?

1059

what is view? : Sql dba

1029

explain the difference between delete , truncate and drop commands? : Sql dba

1147

Is postgresql a nosql database?

1231

Is it mandatory for the primary key to be given a value when a new record is inserted?

1254

how do you control the max size of a heap table? : Sql dba

1031

what is sql in mysql? : Sql dba

1238

What are the two types of exceptions.

1222

How to run sql statements with oracle sql developer?

1123

How many joins in sql?

1059

explain mysql aggregate functions. : Sql dba

1032

Why do we use procedures in pl sql?

1078