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.
Answers were Sorted based on User's Feedback
Answer / guest
Change the object SQL, I mean in SELECT class of that
object conver that by using the to_date or correct syntax.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / 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 |
Answer / yogendra
Go ahead and make the change in the .prm file. So you will
be doing the change only once. And it will be universal for
all the objects.
| Is This Answer Correct ? | 2 Yes | 1 No |
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
What happens in BO when a user logs in to Infoview and a rich client like webi?
filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?
draw the architecture of bo
What is the functional & architectural differences between business objects and web intelligence reports?
How many universe dfi you create if you have 2 years of experience in BO
how do you share the universe ?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
disadvantages of boxi
What do you mean by Object qualification?
wha is the difference b/w merge dimension and combining two different data providers?
can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?