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
- 7056 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
What are slice and dice?
How to publish a package by running Java Script?
How do you call a store procedure within a transformation?
what is degenerate key in oracle ?whare do we use it?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
what is requery in cognos?
What is catalog and types of catalogs in cagonos and which is better?
What is the advantage of using shortcuts?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is called Cognos powerplay?
how to test reports in cognos?
What do you understand by the term 'aggregate cache'?
How create measures and dimensions?
where you can save the report net documentation in our local system?
What are the types of security?
