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

How would you convert date into julian date format?

1006

What is a database trigger?

1071

How to connect a sql*plus session to an oracle server?

1128

What is a nested table in word?

958

what is the difference between $message and $$message? : Sql dba

998

What is case function?

1042

What is restrict in sql?

1120

what is cross join? : Sql dba

998

What is an exception in pl/sql?

1090

List the different type of joins?

1061

What is the difference between sql and t sql?

1036

How to call shell script from pl sql procedure?

1281

Can a select statement fire a trigger?

1164

What is the function that is used to transfer a pl/sql table log to a database table?

1023

What is server name sql?

1148