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!
BI Publisher SQL - Date parameter wrong data
Content
Hi All,
i am trying to execute report with data parameters. In oracle database date column data format is 01-OCT-19 01.40.09.857000000 AM.
whereas in parameter the date is 10/03/2019 (i.e MM/DD/YYYY). Looks like my parameter data is not comparing properly with database format data. please let me know do i need to any conversion? Thanks in advance.
example:
SELECT ID,orderdate FROM order
where orderdate >= '10/02/2019' AND orderdate <= '10/03/2019' order by orderdate ASC
i have to get results for date 10/02 and 10/03 records only with timestamps.
Regards,
Joes