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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

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!