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 / pulakesh
select * from testdate
where to_date(column1,'dd-mon-yyyy')=to_date(column1,'dd-
mon-yyyy') and length(column1)>8
Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What is acid property in a database?
What are some emotional triggers?
What is replication id?
How do you write an index?
What is difference between stored function and application function?
How do you run a query?
How do I remove sql plus from windows 10?
What is clustered and nonclustered index in sql?
What are the different types of database management systems?
How do you optimize a stored procedure in sql?
What does select top 1 do in sql?
What is the purpose of a sql?
what are rollup and cube in t-sql? : Transact sql
What is insert command in sql?
What are local and global Indexes and where they are useful.