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
- 7623 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
Difference between zabo and webi?
U r project in which stage in implementation?
What is package in BO
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Can anybody tell me what are the tuning problems?
Can more than 1 metric be applied on an analytic in business objects?
How to restrict password to a user while sending a document in .pdf format
How to schedule the report in b.o?
What are the join problems comes appart from loop,chasm & fan Traps
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What Is Snow Flake Schema?
Explain what task is 98% of the required work of a business analyst?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain about a time when you discovered a more efficient way to do a work task?
What are the steps to be taken to schedule the report?
