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
- 7777 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
What are the data types present in bo? What happens if we implement view in the designer and report?
How to open a universe with out using the Designer ??
what will be the contents for a functional requirements specifications
how to prepare the documentation in business objects and where to get the requirement?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What is Indexing? how did u implement indexing?
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?
how to create metric universe ?
in sap bi we have wad, then why we go for sap bo
What is thumbnail?
What is the difference between slice and dice and cross tab report?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
any difficulitis have you phase while creating bo reports and how did u solve it
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
