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
- 14278 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / john bershan
select to_char(column_name,'dd-mon-yyyy') from <table_name>;
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Why schema is used in sql?
Does view store data in sql?
What is the purpose of normalization?
What is function and procedure?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is pragma in sql?
explain the difference between bool, tinyint and bit. : Sql dba
What is database sql?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is fmtonly in sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
What is group by in sql?
What are all types of user defined functions?
How do you use collections in procedure to return the resultset?
