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
- 6542 Views
- I also Faced
- E-Mail Answers
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 purpose of @aggregate aware function?please draw, how you use the @aggregate aware function
6 Answers Cap Gemini, Deloitte,
can anybody tell me how many classes where there and objects in each class
How many universes will run maximum in single project
wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.
2.What is loop? How resolve the loop?explain it?
11 Answers TCS, UHG,
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
What are the major problems will occur while migrating to the one version to another version?
what is meant by report busting
How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
WHAT IS SYNCHRONIZATION IN BOXI?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Teradata 
