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
- 6 Answers
- 14719 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
How to add, remove, modify users using sql?
what are numeric data types? : Sql dba
How to create an array in pl/sql?
What is composite data type in pl sql?
What is natural join in sql?
what is an extent ? : Sql dba
what is the difference between delete and truncate commands? : Sql dba
How subquery works in sql?
When you have to use a default "rollback to" savepoint of plvlog?
What is the left table in sql?
What is your daily office routine?
How do I start sql profiler?
What are some predefined exceptions in pl/sql?
Explain the difference between triggers and constraints?
How do I create a sql database?
