Time - Time Zone

> (Data|State) Management and Processing > (Data Type|Data Structure) > Time > Time - (Instant|Date) (representation|type)

1 - About

Timezone settings are quite complex due to the seasonal time changes (Daylight Savings Time vs Standard Time) that occur at different times, across the globe, and/or are not implemented in selected countries.

GMT is a universal standard which does not make any seasonal adjustments (i.e. does not observe Daylight Savings Time).

Advertising

3 - Example: Epoch Time Zone

Consider the timestamp literal TIMESTAMP '1970-01-01 00:00:00'. In the database that has the value 0. But does it represent the epoch (1970-01-01 00:00:00 UTC)? No. There is no time zone.

4 - Documentation / Reference