On Mon, May 18, 2009 at 11:16 AM, Bayless Kirtley <bkirt@cox.net> wrote:
> ----- Original Message ----- From: "John R Pierce" <pierce@hogranch.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@postgresql.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?