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

Answers were Sorted based on User's Feedback



we have a column of int/varchar datatype,but when we run the report we should get the date format ..

Answer / chiru

hi, there are two ways to change date format in cognos....

1) In Query Studio right click on Date key and select the Data format ... Select Format type = "Date" In Right Side u will get different formats of date.. there u can select the Format type and click ok and then run the report


2) In Report Studio, right click on Date key and select Format type is "Date" and right side, display the properties... in Properties select the Date Ordering.. in drop down u will get date formats, select and click ok.. now run the report

Is This Answer Correct ?    1 Yes 0 No

we have a column of int/varchar datatype,but when we run the report we should get the date format ..

Answer / nasa

Hello it is possible...

IN ORACLE:----

Datatype is int or varchar... so first convert into date by using date function


Eg: to_date('20040105','yyyymmdd');

By using to_char() use can extract which format you want or which particular thing you want.. ex: month, year, date, time...


Eg: select to_char(to_date('20030503','yyyymmdd'),'DD Mon Yyyy') from dual;


here answer: 03 May 2003


IF you want this feature in Cognos use extract().


Regards,
Nasa...

Is This Answer Correct ?    1 Yes 0 No

we have a column of int/varchar datatype,but when we run the report we should get the date format ..

Answer / 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

we have a column of int/varchar datatype,but when we run the report we should get the date format ..

Answer / sa

use Extract Function

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Cognos Interview Questions

what is reprompt?

3 Answers   TCS,


What is Report item

1 Answers   TCS,


if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

2 Answers   WNS,


How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.

3 Answers   Kudos India,


What actually a project contains?

0 Answers  






what is the difference between rollup aggregation and aggregation ?

1 Answers  


Is it possible to create drill through access to other report from PDF report?

1 Answers   IBM,


How to select all in value prompt instead of cascade prompt?

3 Answers   IBM,


Define datastores in cognos?

0 Answers  


I want to run one page with filter and another page without filter, what is process?

1 Answers  


can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 Answers  


what is an sid (surrogate key)?

2 Answers   IBM, Oracle,


Categories