ADW not showing sysdate correctly as per timezone
We have deployed ADW in a shared infra and currently facing issues to show "sysdate" correctly as per the customer defined timezone.
Our DB timezone parameter is set as "Australia/Melbourne" and showing correctly when querying
select dbtimezone from dual;
However, when we query
select sysdate from dual
The result is showing date with "UTC" timezone which I understand is the OS timezone.
Is there any way to change the OS timezone/sysdate to show correctly as per the dbtimezone parameter?
We have ODI marketplace for data integrations and due to this ADW sysdate issue, all the integration log timestamp is also showing in the UTC timezone since our ODI-M repository is hosted in the ADW. Our ODI-M compute instance OS timezone is correctly set as "Australia/Melbourne" which enables our integration to run as per the "Australia/Melbourne" data load schedule.