Received: from eCoNeed.com ([147.252.134.34]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f34JR4882770 for ; Wed, 4 Apr 2001 15:27:04 -0400 (EDT) (envelope-from birgit@eCoNeed.com) Received: from eCoNeed.com (localhost.com [127.0.0.1]) by eCoNeed.com (8.11.3/8.11.3) with ESMTP id f34JR6U02779 for ; Wed, 4 Apr 2001 20:27:06 +0100 (IST) (envelope-from birgit@eCoNeed.com) Message-ID: <3ACB7584.F46EAD37@eCoNeed.com> Date: Wed, 04 Apr 2001 20:27:01 +0100 From: Birgit Jansen X-Mailer: Mozilla 4.76 [en] (X11; U; FreeBSD 4.3-BETA i386) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: searching for dates Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/56 X-Sequence-Number: 2395 I am trying to select from a table all rows that have a date befor 1/1/2001 or after some date I am not sure how to do it. I try select date_part('year', start_date) from sometable; and that works but how do I get it to only show me the years between 1990 and 2001 or some othere set of dates. I would realy like to be able to just have a function to tell me if a date in my datebase is befor or after a date? Thanks for any help.