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
Summary
datetime parameters passing in BI publisher reportContent
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 09.45.22.846000000 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).