"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