I Dont the answer in congnos but in ORACLE SELECT TO_CHAR(TO

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

Question Posted / venkapa naidu

4 Answers
7271 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

Please Help Members By Posting Answers For Below Questions

what are slowly changing dimensions? Why we are used scd?

1176

What are initial page components of Cognos connection?

1041

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

4058

What do you understand by the term 'aggregate cache'?

1022

Explain what is the difference between microstrategy and cognos reporting tool?

1139

What are all the types of hierarchies?

1176

Can you define pivot?

1202

What is a Query Subject?

1139

-----------Diff b/w OLAP and RDBMS?

2105

How can you link a query to a data container manually in Report Studio?

2403

how to perform single sign in cognos by using url?

1197

What is Additive function?

2083

How create measures and demensions?

1089

What is the metric store database?

1010

Can you define cognos impromptu?

1076