BI Publisher (MOSC)

MOSC Banner

can we add hours in advance to the date time in the parameters in BI publisher report?

edited Dec 25, 2019 4:00AM in BI Publisher (MOSC) 1 commentAnswered

Hi,

created datetime parameter for the report. based on my server time it is populating date with time in the parameter. But i have to add one hour advance to the current server time in the parameter.

for example:

my server date with time 12/18/2019 02:15:32 PM

but i need to display in the parameter as : 12/18/2019 03:15:32 PM

in data model:  parameter section default value given to {$SYSDATE()$} and date format string given as MM/dd/yyyy hh:mm:ss a

Regards,

RN

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center