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).
0