"wishy wishy" <[EMAIL PROTECTED]> writes: > we have a PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.96 > installation on pogo linux 7.2 > we are facing a data problem when we do the following > select to_char(to_date('1969-10-22','YYYY-MM-DD'),'YYYY-MM-DD');
> ERROR: Unable to convert date to tm Recent versions of glibc broke mktime() for dates before 1970. There is a workaround for this silliness in Postgres 7.2.3. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster