TIMESTAMP normalization
In the previous section, there was an analysis of time zone management by transforming values across multiple zones or by adding a time zone definition from the pure TIMESTAMP value origin.
The world is divided into several time zones that differ by hour or half an hour intervals. Standard time is calculated by the number of hours offset from UTC. UTC provides the precise time secured by multiple laboratories (such as the US Naval Observatory) to serve as a referential value. UTC is a successor of GMT, in that it has taken over as the international standard time where GMT was previously used. Thus, UTC is a referential value to which individual regions apply defined time zones.
There are some examples of shift in the following table. Besides the time zone management itself, a difference related to summer and winter time can be identified as well:
|
Type |
Representation |
