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
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 |
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 |
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 |
advantages of detailed filter??? and summarized filter???
What are the differences between Cognos 8 and Cognos 7.x version?
What is an open session command in cognos connection?what is it meant for?
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
What is the use of Cognos scenario?
..Architectural difference between cognos reportnet and cognos8?
What is snapshot ?
When we save a report in report studio with what extn it save?
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
How can we change any header or footer for a group of reports
1 Answers Satyam, Tech Mahindra,
How to do Performence Tunning in Cognos Reports?