Apparently this did not go through the first time. I'll try again.
> Bayless Kirtley wrote:
>> Thanks Tom and Scott. You got me looking in the right direction. In this
>> case
>> the client and server are on the same machine (testing/development) and
>> psql
>> does return the right result. I tr
- Original Message -
From: "Lew"
To:
Sent: Saturday, May 23, 2009 2:18 PM
Subject: Re: [GENERAL] Daylight saving time question
Bayless Kirtley wrote:
Thanks Tom and Scott. You got me looking in the right direction. In this
case
the client and server are on the sa
Bayless Kirtley wrote:
Thanks Tom and Scott. You got me looking in the right direction. In this
case
the client and server are on the same machine (testing/development) and
psql
does return the right result. I tried all the possibilities from the
java program,
"show timezone", "select current_t
- Original Message -
From: "Tom Lane"
To: "Bayless Kirtley"
Cc: "John R Pierce" ; "PostgreSQL"
;
Sent: Monday, May 18, 2009 3:22 PM
Subject: Re: [GENERAL] Daylight saving time question
"Bayless Kirtley" writes:
Is this
"Bayless Kirtley" writes:
> Is this a flaw in the JDBC driver or is that the expected behavior?
You'd be more likely to get the correct answer on pgsql-jdbc.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
In
either
case I do now have a workaround but would like to know.
Thanks again.
- Original Message -
From: "Tom Lane"
To: "Bayless Kirtley"
Cc: "John R Pierce" ; "PostgreSQL"
Sent: Monday, May 18, 2009 12:26 PM
Subject: Re: [GENERAL]
On Mon, May 18, 2009 at 11:16 AM, Bayless Kirtley wrote:
> - Original Message - From: "John R Pierce"
>> 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'
"Bayless Kirtley" writes:
> 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 stat
- Original Message -
From: "John R Pierce"
To: "Bayless Kirtley" ; "PostgreSQL"
Sent: Sunday, May 17, 2009 10:19 PM
Subject: Re: [GENERAL] Daylight saving time question
Bayless Kirtley wrote:
How can I tell PostgreSQL to use daylight saving time w
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 TIM
10 matches
Mail list logo
