Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Date with timestamp parameter in BI publisher report 12c — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date with timestamp parameter in BI publisher report 12c

edited Oct 11, 2019 5:27PM in Oracle Analytics


datetime parameters passing in BI publisher report


Hi All,

i am creating datewithtime parameterized report.

i have database time column(xx_time) and the data as in the format of  10-OCT-19 AM  -------------> it is in (CST) format. But i have to show in EST format. For that i have used CAST(FROM_TZ(CAST(xx_ba.xx_time AS TIMESTAMP), 'CST') at TIME zone 'America/New_York' AS DATE) AS TIMEST. its working here.

now i have to fetch records on TIMEST (which is calcualted column)  between start date and enddate parameters. whereas parameters datetime format as 10/13/2019 10:30:15 AM (MM/dd/yyyy hh:mi:ss AM).

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!