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
- 6928 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
When we save a report in report studio with what extn it save?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
Write types of folders present in cognos?
is there any difference between operational database and data base?if yes what r they?
What do you mean by drill across?
What is defined as catalog and types of catalogs in Cognos?
Define catalog in cognos and write its various types?
How can I test reports in cagonos?
i have one file i saved in csv how can i take these file into framework manager
Why cognos scenario is used?
What is meant by Reportstudio shortcut?
How to join multiple db in catalog?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
in u r data u having duplicates how to fetch the latest data in our report?
What is looping and how to avoid it in framework manager?
