Which rules does Oracle apply when converting a TIMESTAMP WITH TIME ZONE value after the session NLS_TIME_ZONE changes?
Determine how Oracle Database handles a TIMESTAMP WITH TIME ZONE value when the session’s NLS_TIME_ZONE parameter is changed between the time the value is inserted and the time it is queried. The value is stored with its original time‑zone offset, but retrieval may apply the current session time zone, potentially altering the displayed instant, especially wh