1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

in a database date formate is in dd/mm/yy. In my report I
want when I prompt the date coloumn it should be
displayed in (yyyy/mmm/dd)format.
how could I do this

plse send me as soon as possible.

Question Posted / aditya

Answers were Sorted based on User's Feedback



in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it ..

Answer / guest

Change the object SQL, I mean in SELECT class of that
object conver that by using the to_date or correct syntax.

Is This Answer Correct ?    6 Yes 3 No

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it ..

Answer / aditya

create a derive table for that
select to_char(hire_date,'yyyy/mmm/dd') as date from
employees

it will work when you use in the prompt

Is This Answer Correct ?    4 Yes 1 No

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it ..

Answer / yogendra

Go ahead and make the change in the .prm file. So you will
be doing the change only once. And it will be universal for
all the objects.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Business Objects Interview Questions

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers   BirlaSoft,

how to add duplicte rows to the existing report in webi ?

1 Answers   HCL,

What are the difference between merge,auto merge and extended merge ?

1 Answers   Cap Gemini,

how to restrict null values in webi report?

2 Answers   InfoStep,

can any one tell me how to create a new universe from scrach with step by step process.

4 Answers   HCL,




What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,

Can master data change???if yes then how it'll change.....please explain with example...... thanx

1 Answers  

I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,

What sort of existing documents should business analysts refer to when starting on a new project?

0 Answers  

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

0 Answers   IBM,

i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance

3 Answers   TCS,

How would you format some text using css to be verdana and bold?

0 Answers  

For more Business Objects Interview Questions Click Here
Categories