Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7656 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
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is the functional & architectural differences between business objects and web intelligence reports?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is a fantrap in business objects?
What sort of existing documents should business analysts refer to when starting on a new project?
Explain the difference between detect alias and detect context?
What is the difference between business requirement document and use case document.
Explain how to schedule the report in b.o?
Explain difference between zabo and webi?
How to generate the report from excel sheet?
What is Indexing? how did u implement indexing?
What is the difference between absolute and relative div positioning?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
