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
- 7123 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 METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
How to test a cube?
difference between impromptu and cognos8
How is possible this scenario using in type-in prompt.?
How do we drill through from a powerplay cube to reportnet?\
what are the dimensions that you have in your current project?list them?
Explain the difference between powerplay transformer and power play reports?
How to create a cube in Transformer? What is the process? Please mention process thank u
What are the types of studio present in Cognos?
what is the procedure for scheduling conditional rendering?
What are the types of catalogs in cognos?
Can you define snapshot?
What junk dimension contains?
how you migrate reports to cognos 8 from previous versions?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
