Re: Daylight saving time question

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