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

hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.

0 Answers  

---

what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me

4 Answers   IBM,

---

advantages of cascade prompt ???

3 Answers   iFlex,

---

How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.

2 Answers   Satyam,

---

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers   Infosys,

---

How to generate cubes in cognos?

0 Answers  

---

What do you understand by the term 'aggregate cache'?

0 Answers  

---

what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

2 Answers   IBM,

---

What are the components of the report studio?

0 Answers  

---

how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.

4 Answers  

---

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

3 Answers   CTS, TCS,

---

How do we create Links & Segments in Cognos Framework Manager?

1 Answers  

---