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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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