BI Publisher (MOSC)

MOSC Banner

BI Publisher set the default time to midnight

edited Mar 29, 2016 5:04AM in BI Publisher (MOSC) 4 commentsAnswered

i am trying to set the default time in the data model for a BI Publisher report to midnight.

i am using {$sysdate()$} as the value in the default value column. this sets the time to the current time or time when the report/data model is opened.

i want the report to show the midnight of the current day every time a user opens a report.

I am using mm-dd-yyyy HH:mi:ss as the date format. if i remove HH:mi:ss from the date format, the time is set to midnight but the problem with that approach is that the date widget doesn't show the time picker. so the user can't select the time, they can only select the date.

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