Time - Time Zone
Table of Contents
About
The world is split in 24 time zone (one time zone for one hour).
Time zones are expressed using positive or negative offsets from UTC.
The Time Zone defines then the beginning and the end of a day.
They are political divisions of the earth's surface that allow the convention that time is measured the same at all locations within the time zone, regardless of the precise value of sun time at specific locations.
Articles Related
Example
Property
Id
Example: Europe/Amsterdam
Others Time Scale and Time Zone
Gmt
GMT is a universal standard which does not make any seasonal adjustments (i.e. does not observe Daylight Savings Time).
Epoch
Consider the SQL 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.