Oracle TIMESTAMP w/ timezone data type confusion

Posted by JuiceBox1337 on Stack Overflow See other posts from Stack Overflow or by JuiceBox1337
Published on 2010-05-18T21:10:34Z Indexed on 2010/05/19 1:00 UTC
Read the original article Hit count: 232

Filed under:
|
|
|

When would you use TIMESTAMP w/ timezone as opposed to TIMESTAMP w/ local time zone?

When data is stored in a column of data type TIMESTAMP w/ local tz, the data is normalized to the database time zone, and the time zone displacement is not stored as part of the column data. When users retrieve the data, Oracle returns it in the users' local session time zone.

Isn't that much more useful? I can't think of a reason why I'd want to use TIMESTAMP w/ timezone and get back some gobble gook with a UTC offset.

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about datetime