TimeZone

A GUC determining the server time zone

TimeZone is a configuration parameter determining the server time zone.

TimeZone was added in PostgreSQL 7.3.

Default value

The default value for TimeZone is: GMT.

Note that when initdb is executed, it will generate an entry in postgresql.conf corresponding to the host's time zone.

Change history

Examples

SHOW timezone;
   TimeZone    
---------------
 Europe/Berlin
(1 row)

Categories

Date and time, GUC configuration item

See also

timezone_abbreviations, pg_timezone_names, pg_timezone_abbrevs