APEX : 24.2.11
Within the application defn → Globalization. I have enabled Automatic Time Zone.
I have created a table with two fields
date_field => date
timezone_field => timestamp(6) with time zone
I am inserting sysdate for the date_field and systimestamp for timezone_field.
Within my classic report in apex, the time for both fields is showing the database timezone(the time the record was created) rather the time for my timezone(which is different to the DB).
Does the “ Automatic Time Zone” option work . If so, how do you get working ?
I have also tried using APEX_UTIL.SET_SESSION_TIME_ZONE in a post authentication procedure for the apex authentication schema. This does not work.
Any assistant would be appreciated.
Thanks