Skip site navigation (1) Skip section navigation (2)

Re: Bug #803: Problem with timestamp conversion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sysop(at)jfpr(dot)gov(dot)br, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #803: Problem with timestamp conversion
Date: 2002-10-23 19:07:21
Message-ID: 3299.1035400041@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
> SELECT * FROM Noticia WHERE data >= CURRENT_DATE - 10
> and returns: Unable to convert data to tm.

Curious.  This seems to indicate that mktime() is failing, which
as far as I can see it should not do.  Is 13/10/2002 a daylight-savings
transition day in your timezone?  What is your timezone, anyway?

You might find that updating to PG 7.2.3 solves your problem.  We put
in a hack to work around mktime() breakage in recent glibc versions.
Even though your case does not seem to directly relate to that issue,
the new code should cover up mktime's problem anyway.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-10-23 19:22:54
Subject: Re: [BUGS] psql does not invoke pager on \h *
Previous:From: Tom LaneDate: 2002-10-23 18:35:12
Subject: Re: Solved: SQL Query Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group