It might have been written umpteen times here and there, but it always manages to confuse me. So, here it is another time on the internet...
With due respect to - http://toolkit.rdbms-insight.com/tz.php
| Datatypes | ||
|---|---|---|
| Timestamp/timezone datatype | What Oracle stores | What Oracle displays |
| TIMESTAMP WITH TIME ZONE | Year, month, day, hour, minute, second, fractional second, and time zone displacement (HH:MI difference from GMT) | Stored value |
| TIMESTAMP WITH LOCAL TIME ZONE | Year, month, day, hour, minute, second, fractional second; does NOT store time zone information, but instead converts data to the database time zone and stores it w/o time zone information | Converts the stored data to the session's time zone before displaying |
With due respect to - http://toolkit.rdbms-insight.com/tz.php
No comments:
Post a Comment