X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C419ED1CB0F for ; Sun, 15 Feb 2004 22:02:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 07618-02 for ; Sun, 15 Feb 2004 18:02:23 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 19CF5D1C517 for ; Sun, 15 Feb 2004 18:02:21 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1FM2B2H010950; Sun, 15 Feb 2004 17:02:12 -0500 (EST) To: Ramiro Arenas R Cc: pgsql-sql@postgresql.org Subject: Re: Unable to convert date to tm In-reply-to: <1076445948.5346.12.camel@maxims.coordinadora.com> References: <1076445948.5346.12.camel@maxims.coordinadora.com> Comments: In-reply-to Ramiro Arenas R message dated "Tue, 10 Feb 2004 15:45:49 -0500" Date: Sun, 15 Feb 2004 17:02:11 -0500 Message-ID: <10949.1076882531@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/181 X-Sequence-Number: 16871 Ramiro Arenas R 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