Re: Unable to convert date to tm

"Joerg Ludwig" <joerg.ludwig@hvf-bs.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