in a database date formate is in dd/mm/yy. In my report I
want when I prompt the date coloumn it should be
displayed in (yyyy/mmm/dd)format.
how could I do this
plse send me as soon as possible.
- 3 Answers
- 6509 Views
- I also Faced
- E-Mail Answers
Answer Posted / aditya
create a derive table for that
select to_char(hire_date,'yyyy/mmm/dd') as date from
employees
it will work when you use in the prompt
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain what are the measure objects?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
Explain about alerts in bos, under what situation we need to use alerts?
What are the steps to do to use alerts in bo?
How would you format some text using css to be verdana and bold?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the difference between condition & filter?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain about a task that really tested your analytical abilities?
What is the difference between business requirement document and use case document.
Did you face any problems while creating reports? Name? Solutions?
What is the difference between datawarehousing and businessintelligence?
Explain what are the steps to do to use alerts in bo?
What are all difference between business objects 6.5 and xi r2?
8. How much supervision have you typically received in your previous job?
