| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Andrew Chernow <ac(at)esilo(dot)com> |
| Cc: | 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 08:08:07 |
| Message-ID: | 20071210080807.GA10368@feivel.credativ.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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(at)jabber(dot)org
Go SF 49ers! Go VfL Borussia! Use Debian GNU/Linux! Use PostgreSQL!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2007-12-10 08:51:45 | Re: Release Note Changes |
| Previous Message | Dave Page | 2007-12-10 07:44:07 | Re: Release Note Changes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2007-12-10 09:56:39 | Re: [HACKERS] Problem with ControlFileData structure being ABI depe ndent |
| Previous Message | Bruce Momjian | 2007-12-10 00:34:12 | Re: pt_BR FAQ update |