For more information, please refer to this announcement explaining best practices for getting answers to questions.
Is it possible to change time zone on CURRENT_DATE SQL filter?
Summary
We have noticed that when we use CURRENT_DATE as a filter, the data is pulled using UTC time as the current date. Has anyone else run into this issue?Content
Hi HCM Reporting Community!
We are putting together a bunch of report tiles that pull transactions from different subject areas in the past day. We have used the following filter to get these transactions:
Creation Date is greater than or equal to CURRENT_DATE
This filter works well, but it thinks the current date is from 7pm-7pm on any given day, not 12am-12am. I think this is the result of the database counting days based on UTC time. How can we change this so we can accurately capture a given day's values? Is it possible to change the timezone from UTC to local time on a system level for OTBI? Has anyone else run into this issue? To be clear, the values themselves at showing in our correct local time zone, it is just the CURRENT_DATE filter that is pulling the wrong time zone.