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 / dipti
select * from TABLE1
where VSIZE(column_name) > (select VSIZE('DD-MON-YYYY') from dual)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between truncate and drop statements?
What is difference between left and right outer join?
What are the different types of a subquery?
What is rename command in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
Explain about various levels of constraint.
What are keys in sql?
what is denormalization. : Sql dba
What does joining a thread mean?
what are date and time data types? : Sql dba
What is nvarchar in sql?
what are the different type of sql's statements ? : Sql dba
What is procedure in pl sql?
Can a trigger call a stored procedure?
What is sql query optimization?