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 / 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
What are the sql aggregate functions?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is the difference between sum and count in sql?
How do you determine the current isolation level? : Transact sql
What does varchar include?
how to fetch alternate records from a table? : Sql dba
What is multiple columns?
Which is the correct statement about truncate and delete?
what is table? : Sql dba
What does 0 mean in sql?
Which is faster view or stored procedure?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what is a join? : Sql dba
What are pl/sql cursors?