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
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 do you mean by drill across?
how u will determine the performence tune will occur either in report or system
What is metric store database?
how you migrate reports to cognos 8 from previous versions?
Which studio is used to create reports?
---------------Tell me about DWH Concepts?
What junk dimension contains?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
Is it possible to join multiple Databases in a Catalog?
What is looping and how to avoid it in framework manager?
what is the main advantage of impromptu over cognos reportnet?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
what is online view?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
what is catalog and types of catalogs in cagnos and which is better?