APEX

Hi everyone,

I’m using the Approvals / Workflow feature in Oracle APEX. The runtime views provided include:

• APEX_TASKS
• APEX_TASK_COMMENTS
• APEX_TASK_HISTORY
• APEX_TASK_PARAMETERS
• APEX_TASK_PARTICIPANTS

According to the official documentation, these views expose columns such as CREATED_ON, LAST_UPDATED_ON, and EVENT_TIMESTAMP, which are of type TIMESTAMP WITH TIME ZONE.

The issue is that all these date values are shown in UTC, but I’m located in Colombia (America/Bogota, UTC-5) and would like to display them in my local time zone.

For example:

SELECT
  TASK_ID,
  LAST_UPDATED_ON,
  LAST_UPDATED_ON AT TIME ZONE 'America/Bogota' AS LAST_UPDATED_CO,
  CURRENT_TIMESTAMP
FROM APEX_TASKS;

However, this still shows UTC timestamps (no visible offset change).

SQL Developer result:

My questions:

1. Is there any global APEX configuration that allows the runtime approval views (APEX_TASKS, APEX_TASK_HISTORY, etc.) to automatically display timestamps in the user’s session time zone instead of UTC?
2. Or do I have to explicitly convert every timestamp column using something like AT TIME ZONE SESSIONTIMEZONE?
3. What’s the recommended best practice for handling time zone conversions in APEX approval workflows, so timestamps appear in the user’s local time?

Any tips or examples are appreciated — thank you!