Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EE73B475D64 for ; Fri, 18 Oct 2002 15:19:08 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 46416475C2B for ; Fri, 18 Oct 2002 15:19:08 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g9IJJ7hR024292; Fri, 18 Oct 2002 15:19:07 -0400 (EDT) To: "wishy wishy" Cc: pgsql-sql@postgresql.org Subject: Re: date In-reply-to: References: Comments: In-reply-to "wishy wishy" message dated "Fri, 18 Oct 2002 10:24:50 -0000" Date: Fri, 18 Oct 2002 15:19:07 -0400 Message-ID: <24291.1034968747@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/245 X-Sequence-Number: 9962 "wishy wishy" 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