Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7102 Views
- IBM, I also Faced
- E-Mail Answers
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 you create security to reports?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is the use of report studio?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
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.
in u r data u having duplicates how to fetch the latest data in our report?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Explain the difference between powerplay transformer and power play reports?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Can you define slice?
i was asked what are the caluclations done by you in your report? plz give reply
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What are the themes in a data warehouse?
What is the function of cognos dispatcher?
What are the components of the report studio?
