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
- 14717 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / praveen
select to_date('Column_Name','dd-mon-yyyy') from table_name;
| Is This Answer Correct ? | 23 Yes | 15 No |
Post New Answer View All Answers
Does sql*plus have a pl/sql engine?
What is nested table in pl sql?
What are dml commands?
What does rownum mean in sql?
What is cartesian join in sql?
Difference between global and parameter variables?
How does postgresql compare to oracle/db2/ms sql server/informix?
What do you mean by query optimization?
What are the basic sql commands?
What is a trigger word?
Explain how can you save or place your msg in a table?
Mention what plvcmt and plvrb does in pl/sql?
Can I join the same table twice?
What are the rules to be applied to nulls whilst doing comparisons?
What is bind reference and how can it be created?
