I Dont the answer in congnos but in ORACLE SELECT TO_CHAR(TO

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 / venkapa naidu

4 Answers
7064 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / 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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention the difference between ‘macros’ and ‘prompt’?

1137

How to create a cube in Transformer? What is the process? Please mention process thank u

1758

Can you define snapshot?

912

When we save a report in report studio with what extn it save?

1060

Can you define confirmed dimension?

1073

----------------Diff b/w Dimensional modeling and Relational modeling?

14980

What is called materialized view?

1063

what is a prompt value in report studio and variables ?

2701

What are the main services provided by application tier?

977

what are the filters in framework manager and report studio?

986

Can you explain new content durability?

1017

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

996

whats the difference between previous version of cognos and cognos 8 BI?

5527

What is the enterprise class platform architecture of cognos 8?

1024

What are all the advantages of Cognos?

1034