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
- 14720 Views
- Accenture, I also Faced
- E-Mail Answers
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
how can you see all indexes defined for a table? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is the use of double ampersand (&&) in sql queries? Give an example
what is heap table? : Sql dba
Why left join is used in sql?
Write a unique difference between a function and a stored procedure.
Compare sql & pl/sql
How to Execute a Package in PL/SQL.?
How can we solve sql error: ora-00904: invalid identifier?
Which kind of parameters cannot have a default value in pl sql?
What is percent sign in sql?
describe mysql connection using mysql binary. : Sql dba
What is minus?
What are the two types of periodical indexes?
How to revise and re-run the last sql command?
