Postgres Pro
Downloads
Home   >   mailing lists

Re: Daylight saving time question - Mailing list pgsql-general

From John R Pierce
Subject Re: Daylight saving time question
Date
Msg-id 4A10D3C3.9090109@hogranch.com
Whole thread Raw
In response to Daylight saving time question  ("Bayless Kirtley" <bkirt@cox.net>)
List pgsql-general
Tree view 
Bayless Kirtley wrote:
> How can I tell PostgreSQL to use daylight saving time when applicable?
> Times returned by the database are one hour behind.

it uses your client's specified local time zone to determine whether or
not DST is in effect.

    SET TIME ZONE 'America/New York';

or

    SET TIME ZONE 'PST8PDT';

pgsql-general by date:

Previous
From: "Bayless Kirtley"
Date:
Subject: Daylight saving time question
Next
From: Paolo Saul
Date:
Subject: Is this a bug or a feature? Column visibility in subquery from outer query