1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

we have a column of int/varchar datatype,but when we run
the report we should get the date format
i.e., suppose date key is a query item consists of data as
20040105,20030503,20060410.......
output should be 5 jan 2004,3 may2003,10 apr
2006..........respectively.Can i knnow the answer

Question Posted / nasa

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of model design accelerator?

539

Can you explain a cognos controller?

598

What is the use of powerhouse?

613

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

910

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

1693




Please explain the different stages in creating a report in cognos report net?

564

Define olap designer?

703

What are the other methods working as deployment functionality?

521

How to select multiple values from type-in prompt?

643

What is the complex report you faced in real time?

1731

What are the methods by which it non-durable model could be changed into the durable model?

523

Can you define fan trap?

748

What are products of cognos?

558

is there any difference between operational database and data base?if yes what r they?

1588

What are the considerations regarding performance kept in mind while setting up cognos?

564