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

Hi Experts, Can a single package be shared by multiple users?

3 Answers  

---

where do we see the run time of the report ?

2 Answers  

---

hi friends pls forward impropmtu interview question

0 Answers  

---

hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers   TCS,

---

difference between boxtype and visiable

1 Answers   IBM,

---

How do add dynamic titles in PP?

3 Answers  

---

How can we migrate from Businees Objects reports to Cognos 8.x??

1 Answers  

---

What is the metric store database?

0 Answers  

---

how can you set the image in the report

1 Answers   HSBC,

---

How do we run stored procedure?

1 Answers  

---

What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....

4 Answers  

---

what is the difference between list report and crosstab report?

0 Answers   IBM,

---