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
- 7727 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 happens if cardinalities are not resolved?
What task is 98% of the required work of a business analyst?
How to schedule the report in b.o?
what is fantrap?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
What is thin client And thick client..?
how we improve the performance of report and universe?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
How to check for a particular value from one column with the list of values present in another column in Webi reports?
Teradata 
