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

what are the errors faced while bursting the reports and how to solve those errors?

2064

---

tell me two or three issues from client side and how to solve those issues?

2213

---

-------------What is Coditional Prompting?

2221

---

What is a Folder?

1235

---

What is main difference mapplets and mapping?

1267

---

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2417

---

What are the types of folder present in cognos?

1136

---

Why is auto-regression used in forecasting used on cognos platform?

1071

---

What you mean by drill across?

1072

---

What is the difference between ‘macro’ and ‘prompt?

1141

---

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

1010

---

How create measures and demensions?

1089

---

Write types of folders present in cognos?

1122

---

How can I test reports in cagonos?

1012

---

How do you call a store procedure within a transformation?

1049

---