How to use timestamp with local time zone in Oracle APEX
In this post I will cover the basics of using a column type timestamp with local time zone in Oracle APEX, this is a simple way that will help us to show date-time information in users timezone. First will be required to enable the Automatic Time Zone option from Shared Components -> (Globalization) Global Attributes menu: This will help us to automatically set the time zone each time a user logs in in our application, same result can be achieved calling the procedure APEX_UTIL.SET_SESSION_TIME_ZONE in an Application Process after authentication, the only difference is that you have to provide the time zone with the procedure. Time zone is set, now we can work on the table, data and page, I will create a simple table with three columns: Identifier Timestamp with time zone Timestamp with local timezone After that will insert one record to this table setting the SYSTIMESTAMP in both timestamp columns, and then create four Display Only items in the page q...