Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 80EDC9FB990 for ; Tue, 16 Oct 2007 15:09:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43775-04 for ; Tue, 16 Oct 2007 15:09:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mtai02.charter.net (mtai02.charter.net [209.225.8.182]) by postgresql.org (Postfix) with ESMTP id 8E6C79FB985 for ; Tue, 16 Oct 2007 15:09:22 -0300 (ADT) Received: from aarprv02.charter.net ([10.20.200.72]) by mtai02.charter.net (InterMail vM.7.08.03.00 201-2186-126-20070710) with ESMTP id <20071016180906.WKMI28.mtai02.charter.net@aarprv02.charter.net>; Tue, 16 Oct 2007 14:09:06 -0400 Received: from [10.0.1.2] (really [66.188.156.151]) by aarprv02.charter.net with ESMTP id <20071016180906.IEGC495.aarprv02.charter.net@[10.0.1.2]>; Tue, 16 Oct 2007 14:09:06 -0400 In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <3DA72981-52FC-4044-A24A-D513FF3947DE@seespotcode.net> Cc: Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: what's wrong with my date comparison? Date: Tue, 16 Oct 2007 13:09:03 -0500 To: "Tena Sakai" X-Mailer: Apple Mail (2.752.2) X-Chzlrs: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/77 X-Sequence-Number: 29449 On Oct 16, 2007, at 12:57 , Tena Sakai wrote: > select name, value, datecreated > from mytable > where datecreated > 2007-10-02; where datecreated > '2007-10-02' 2007-10-02 = 1995. # select current_date < 2007-10-31 as arithmetic_comparison, current_date < '2007-10-31' as date_comparison; arithmetic_comparison | date_comparison -----------------------+----------------- f | t (1 row) Michael Glaesemann grzm seespotcode net