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

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

3 Answers
7645 Views
I also Faced
E-Mail Answers

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

How will you move reports from Dev to QA in BO

3 Answers Infosys,

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers

how do we apply sql query on selected variables?

3 Answers

What are the security level used in BO?

6 Answers Oracle,

HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?

3 Answers

What are the advantages of Xcelsius & Crystal reports over Infoview?

1 Answers Reliance,

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers

how many times can use the union operator in a report?

3 Answers

Shall we connect to the oltp systems directly .,

2 Answers iNautix,

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

2 Answers BirlaSoft,

Tell me about a complicated object you have created?

1 Answers

Can we have multiple domains?

3 Answers

For more Business Objects Interview Questions Click Here