Re: Daylight saving time question

On Mon, May 18, 2009 at 11:16 AM, Bayless Kirtley <bkirt(at)cox(dot)net> wrote:
> ----- Original Message ----- From: "John R Pierce" <pierce(at)hogranch(dot)com>
>> 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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
> For some reason I can't seem to make it work. I have tried setting the
> timezone
> in postgresql.conf as "timezone = 'America/Chicago'" and "timezone =
> 'CST6CDT'"
> both of which still returned one hour behind. I also tried both of your
> suggestions
> as SQL statements right after establishing a database connection and still
> get the
> same wrong time.

It's not about what's set in postgresql.conf, it's what the client
timezone is. If you connect from your client and issue "show
timezone;" what do you get?

> I have a Java application on Windows XP PRO and the way I am getting the
> time is "Select CURRENT_TIME". Is there something I am missing or is there
> another way I should be getting the time?

Nope, sounds right. Again, what's the client application think the timezone is?