Answer / chiru

hi, there are two ways to change date format in cognos....

1) In Query Studio right click on Date key and select the Data format ... Select Format type = "Date" In Right Side u will get different formats of date.. there u can select the Format type and click ok and then run the report


2) In Report Studio, right click on Date key and select Format type is "Date" and right side, display the properties... in Properties select the Date Ordering.. in drop down u will get date formats, select and click ok.. now run the report

Answer / 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...

Answer / 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

Answer / sa

use Extract Function

what is the difference between a data item and a query item?

2 Answers   Bodhtree, HP,

---

Why cognos scenario is used?

1 Answers  

---

what is catalog and types of catalogs in cagnos and which is better?

1 Answers   IBM,

---

I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos

1 Answers   IBM,

---

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

3 Answers   Infosys, Wipro,

---

What is the use of Tree Prompt? Where it is used?Pls give me a real time example?

1 Answers  

---

---------------Tell me about DWH Concepts?

1 Answers   Bank Of America,

---

plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?

2 Answers  

---

What are all the types of report?

1 Answers  

---

Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,

---

------------------What is Inline Query?

1 Answers   Cap Gemini,

---

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1 Answers  

---