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
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go VfL Borussia! Use Debian GNU/Linux! Use PostgreSQL!