Re: Daylight saving time question

[John R Pierce <pierce@xxxxxxxxxxxx>]

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';



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general