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
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 many sectors are in a partition?
How do you create a db file?
How to make a copy values from one column to another in sql?
What is program debugging?
How many subqueries can be nested in a statement?
Is nosql relational?
Is ms sql is free?
Can we use join in subquery?
what are enums used for in mysql? : Sql dba
What is sqlcommand?
What is primary key secondary key alternate key candidate key?
How to start the command-line sql*plus?
Does a user_objects view have an entry for a trigger?
how many tables will create when we create table, what are they? : Sql dba
What does trigger mean in psychology?