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
- 7907 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 are cascading prompts explain with steps
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash
HOW TO PUBLISH A REPORT IN BO?
How to change the order of prompts in universe?
what is mean by lov?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
any of the person working on encyclopedia? give the explanation briefly?
When we use aggregate awareness function in designer?
Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Teradata 
