Обсуждение: Unable to convert date to tm

Hi

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

where using a cast like this: "SELECT  * FROM table WHERE x  
>='2004-01-01::timestamp" result is ok but it doesn't use index.

Thanks in advance.

Ramiro Arenas R <ramiroa@coordinadora.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