How to convert the date format from dd/mm/yyyy to
mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008.
when u use to_char(), it tells the month is invalid. how to
resolve this problem.tel with eg.
- 2 Answers
- 9581 Views
- AppLabs, I also Faced
- E-Mail Answers
Answer Posted / pinki
again convert in back to date using to_date
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
candidate key is subset of super key but not vice-verse explain
How will you identify oracle database software release?
What is meant by joins?
What do you mean by merge in oracle and how can we merge two tables?
What are nested tables?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is an oracle user role?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How can I introduce multiple conditions in like operator?
What happens if recursive calls get out of control?
How do we represent comments in oracle?
What is oracle rowcount?
What is a private synonym?
What is PL/SQL ?
How to enter a new row into a table interactively?
