Time - Time Zone

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.

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.

Language

Documentation / Reference


Powered by ComboStrap