From: | Andrew Chernow <ac(at)esilo(dot)com> |
---|---|
To: | Andrew Chernow <ac(at)esilo(dot)com>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org, Merlin Moncure <mmoncure(at)gmail(dot)com> |
Subject: | Re: PGparam timestamp question |
Date: | 2007-12-10 12:39:05 |
Message-ID: | 475D3369.1080403@esilo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
>>Or was the code incorrectly used?
Hard for me to say, but I think its about caller context. The way I am using it
might be different ... hey the function was static ... copy & paster be warned!
The code appears to be doing the same thing as the backend (with the exclusion
of backend stuff like HasCTZSet and forced conversions). I plan to do an
extensive test sometime today. So far, I am getting the correct timestamp
conversions across the board.
Andrew
Michael Meskes wrote:
> On Sun, Dec 09, 2007 at 11:54:25AM -0500, Andrew Chernow wrote:
>> That explains why my libpq code was getting 3AM for "without time zone"
>> values. I am using code from src/interfaces/ecpg/pgtypeslib/timestamp.c
>> timestamp2tm(). That uses localtime() after converting the timestamp to an
>> epoch value. I changed this code so that it calls gmtime() for
>> TIMESTAMPOID and localtime() for TIMESTAMPTZOID. Now it works perfectly :)
>
> Does this mean pgtypeslib is buggy? This code has been taken from the
> backend ages ago, so some changes might have occured that I'm not aware
> of. Or was the code incorrectly used?
>
> Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2007-12-10 13:13:14 | Re: Release Note Changes |
Previous Message | Dave Page | 2007-12-10 12:31:50 | Re: Release Note Changes |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-12-10 12:41:56 | Re: plpgsql, forc statement |
Previous Message | Dave Page | 2007-12-10 09:56:39 | Re: [HACKERS] Problem with ControlFileData structure being ABI depe ndent |