Time - Time Zone


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.




Example: Europe/Amsterdam

Others Time Scale and Time Zone


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


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.


Documentation / Reference

Powered by ComboStrap