Received: from mta2.snfc21.pbi.net (mta2.snfc21.pbi.net [206.13.28.123]) by hub.org (8.9.3/8.9.3) with ESMTP id CAA09844 for ; Wed, 27 Oct 1999 02:49:06 -0400 (EDT) (envelope-from postgres@weblynk.com) Received: from pinto.usedcars.com ([206.170.239.155]) by mta2.snfc21.pbi.net (Sun Internet Mail Server sims.3.5.1999.09.16.21.57.p8) with SMTP id <0FK9000CX1K740@mta2.snfc21.pbi.net> for pgsql-sql@postgreSQL.org; Tue, 26 Oct 1999 23:48:08 -0700 (PDT) Date: Tue, 26 Oct 1999 23:46:04 -0700 From: Rich Ryan Subject: Date comparisons To: "pgsql-sql@postgresql.org" Message-id: <00bf01bf2046$f18fdcc0$9befaace@usedcars.com> MIME-version: 1.0 X-Mailer: Microsoft Outlook Express 5.00.2314.1300 Content-type: text/plain; charset="iso-8859-1" Content-transfer-encoding: 7bit X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 References: <17667.940862730@sss.pgh.pa.us> <003001bf1f02$39e0e960$9befaace@usedcars.com> X-Priority: 3 I'm trying to do a > < on a date field. Not having any luck. My query looks like select * from a where a.cdate > Date('10-20-1999'); I've tried every different date string format I can think of with no dashes, colons, different orderings of the month, date, and year, etc. no luck. Any hints? Thanks, Rich