Skip site navigation (1) Skip section navigation (2)

TimeZone parameter in postgresql.conf

From: Majid Azimi <majid(dot)merkava(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: TimeZone parameter in postgresql.conf
Date: 2012-09-05 18:03:11
Message-ID: CADOhCmuhk+bWxTcMe2AAyYbnZXia-P+oF9dd0y-y_5OCedCVRQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
postgresql documentation says:

All timezone-aware dates and times are stored internally in UTC. They are
converted to local time in the zone specified by the timezone configuration
parameter before being displayed to the client.

timezone parameter is a session
parameter<http://www.postgresql.org/docs/9.1/static/runtime-config-client.html#GUC-TIMEZONE>.
When all TIMESTAMP WITH TIME ZONEs will be stored as UTC and the client
connection will specify the session timezone, then what is the benefit of
setting TimeZone parameter in postgresql.conf?

Responses

pgsql-novice by date

Next:From: Steve CrawfordDate: 2012-09-05 18:56:14
Subject: Re: TimeZone parameter in postgresql.conf
Previous:From: Matt MusgroveDate: 2012-09-05 15:15:28
Subject: Re: Get file size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group