Fusion BI Report Time zone issues in report output related queries
Our users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries before we proceed to update all the report code.
- Parameters have an option whether to be input in UTC using the ignore timezone flag. So if the “ignore time zone” option is checked then no date conversions are needed is what we assume. Is this correct?
- Similarly internal sysdate and current_date are in UTC and when comparing with other table date fields which are all in UTC, so we believe we don’t need a date conversion in such cases.
1