When will you use TIMESTAMP w / timezone as opposed to TIMESTAMP with a local time zone?
When data is stored in a TIMESTAMP w / local tz data type column, the data is normalized to the database time zone, and the time zone offset is not saved as part of the column data. When users retrieve data, Oracle returns it to the user's local session zone.
Isn't that a lot more useful? I can't think of a reason why I want to use TIMESTAMP w / timezone and return some gobble gook with a UTC offset.
source
share