Hello friends,
I am using Oracle APEX version 21.1 in OCI where I am capturing SYSTIMESTAMP to save any transaction in my APEX application which gets saved in UTC.
While displaying the date and time, I want to display the local time say of Sydney/Australia.
I can use the following to get the local time:
SELECT SYSTIMESTAMP AT TIME ZONE 'Australia/Sydney' FROM DUAL;
But to know the list of available Time Zones in Oracle DB, I used the following query:
SELECT * FROM gv$timezone_names;
It returned TZNAME, TZABBREV and CON_ID. It seems the TZABBREV is for daylight saving hours.
Can anyone kindly let me know how to use both TZNAME, TZABBREV values in the above query to get the correct local time from UTC.
Thanks and Regards
Hawker