On 8/28/2014 10:06 PM, Vinayak wrote:
Any idea how can we set OS timezone on PostgreSQL?
timestamp with time zone values are stored as the equivalent of UTC and converted to the client TIME_ZONE setting for display, unless you specify some other timezone via AT TIME ZONE
I'm not sure why any other behavior would be rational. -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
