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
- 7730 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 which versions are used in the bo dashboard work?
Can Bo generates the Report from the cubical data Explain?
How we drill up week to month?
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
What would you consider as your biggest achievement and why?
What are the steps to do to use alerts in bo?
What three things do you consider to be the most important factors for a manager?
What is the difference between condition & filter?
Explain the difference between union and group?
What is difference between custom hierarchy and report based hierarchy?
is it possible to export the webi reports to crystal reports?with out using businessview?
Can more than 1 metric be applied on an analytic in business objects?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
how to prepare the documentation in business objects and where to get the requirement?
how to create reports on screech?
