I have been trying to figure out how to set time in my application to my current time zone. I display it on the reports I am creating so the user knows when the report was created.
I have attempted to in Security Attributes/Database Session by using this:
begin
execute immediate 'ALTER SESSION SET TIME_ZONE = ''-05:00''';
end;
The time_value application item queried by using an Application computation to get the time uses:
SELECT TO_CHAR(SYSDATE,'HH12:MI PM')
FROM DUAL;
and when I populate the Application item and post it on my report, it is always at GMT time zone and not EST/EDT time zone.
I am a beginner to Apex/Oracle Cloud, so please be patient with me. What am I doing wrong?