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
- 6336 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
Can you define snapshot?
What is a Datastore in Cognos?
How is cognos model organization works?
What is defined as catalog and types of catalogs in Cognos?
What do you understand by the term 'aggregate advisor?'
what are the errors faced while bursting the reports and how to solve those errors?
What DB View and Bus View?
how to explain health care project and which reports we can create in health care doain?
what is power prompt in cognos ep7series?what is the use of this?
What is set to be Cognos configuration?
What do you understand by the cognos?
How do we convert from Numeric to be Words?
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.
What is a Framework manager?
What is difference between page break and section report?
