Ramiro Arenas R <ramiroa(at)coordinadora(dot)com> writes:
> I have a column x in a table of type date and i have an index on x
> runing the query "SELECT * FROM table WHERE x >= '2004-01-01"
> i get this:
> Unable to convert date to tm
AFAICT, that error message hasn't existed in PG since 7.1. If you
are running 7.1.* or older, I'd suggest an update. The particular
issue here seems to be that 7.1 does not contain a workaround for
broken mktime() library routines that reject dates before 1970.
regards, tom lane