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: (view raw, whole thread or download thread mbox)
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
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?


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-2017 The PostgreSQL Global Development Group