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 / 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 |
Post New Answer View All Answers
How can you link a query to a data container manually in Report Studio?
What do you understand by the term 'aggregate cache'?
what is stitch query in reportnet?
How can I test reports in cagonos?
How is cognos model organization works?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Why cognos decision stream is used?
What are the types of folder present in cognos?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
Can you define cognos decision stream?
Why cognos scenario is used?
whats the difference between previous version of cognos and cognos 8 BI?
how u will determine the performence tune will occur either in report or system
What are the types of security?
How to a create header dynamically in a crosstab report in cognos 8.1?