X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2C8949DCBFC for ; Fri, 17 Mar 2006 09:39:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76460-04 for ; Fri, 17 Mar 2006 09:39:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mta2.siol.net (mta2.siol.net [193.189.160.132]) by postgresql.org (Postfix) with ESMTP id 15E129DC9BC for ; Fri, 17 Mar 2006 09:39:52 -0400 (AST) Received: from edge2.siol.net ([10.10.10.211]) by mta1.siol.net with ESMTP id <20060317131144.NEVL21004.mta1.siol.net@edge2.siol.net> for ; Fri, 17 Mar 2006 14:11:44 +0100 Received: from [190.190.1.108] (really [193.77.157.214]) by edge2.siol.net with ESMTP id <20060317131140.QQQS7870.edge2.siol.net@[190.190.1.108]> for ; Fri, 17 Mar 2006 14:11:40 +0100 Subject: Checking if date is inside date range From: Jure Kodzoman To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: Hrvatski planinarski savez Date: Fri, 17 Mar 2006 14:07:38 +0100 Message-Id: <1142600858.5831.5.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/249 X-Sequence-Number: 24595 Hy list, I would like to check if date is inside a given date range. For instance if date range is datestart column: 10/10/2005 dateend column: 10/20/2005 I would like to return columns for date = 10/15/2005 and not if i enter let's say date = 10/21/2005 thanks for your help, Jure Kodzoman