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

Cleared COG-112 with 100% score today. What next certification should i go for?

1784

---

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

1967

---

how to perform single sign in cognos by using url?

1083

---

what is log in cognos?

1140

---

How do you improve the performance of the Cognos Analytics report

975

---

Can you define snapshot?

881

---

Explain informatica architecture?

935

---

Name the types of gateway?

964

---

Write types of folders present in cognos?

1023

---

What is model?

912

---

Explain what is the difference between native sql and cognos sql?

940

---

can you tell me what are the dimension tables are used in project

2251

---

What is the difference between Standard and Metrics folder?

997

---

Explain what is the difference between microstrategy and cognos reporting tool?

1004

---

How to publish a package by running Java Script?

2031

---