Interested to Buy Any Domain ? << Click Here >> for more details...
we have a column of int/varchar datatype,but when we run
the report we should get the date format
i.e., suppose date key is a query item consists of data as
20040105,20030503,20060410.......
output should be 5 jan 2004,3 may2003,10 apr
2006..........respectively.Can i knnow the answer
- 4 Answers
- 6874 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / venkapa naidu
I Dont the answer in congnos but in ORACLE
SELECT TO_CHAR(TO_DATE(Value,'J'),'DD-MON-YYYY') FROM DUAL;
is the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is defined as data mining?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What is meant by Reportstudio shortcut?
What is defined as Cognos Impromptu?
can you tell me what are the dimension tables are used in project
What is the difference between a data mart and a data warehouse?
what is online view?
What is set to be Cognos configuration?
--------------Explain Table of contents?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What is a Cube?
What are all the types of indexes in Cognos?
how to perform single sign in cognos by using url?
how u will determine the performence tune will occur either in report or system
