Re: Unable to convert date to tm

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joerg Ludwig" <joerg(dot)ludwig(at)hvf-bs(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Unable to convert date to tm
Date: 2002-09-16 13:30:41
Message-ID: 26163.1032183041@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Joerg Ludwig" <joerg(dot)ludwig(at)hvf-bs(dot)net> writes:
> # SELECT (date '1969-12-31')::timestamp;
> ERROR: Unable to convert date to tm

Let me guess --- 7.3 Red Hat installation?

This is brain damage in mktime() in recent glibc releases; they
arbitrarily decided to stop supporting pre-1970 dates.

We've patched around it for Postgres 7.3, but there's no fix available
for existing PG releases. Send complaints to the glibc folk.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-09-16 13:32:40 Re: Web page
Previous Message Tom Lane 2002-09-16 13:27:33 Re: Explicit timestamp conversion very slow