searching for dates

From: Birgit Jansen <birgit(at)eCoNeed(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: searching for dates
Date: 2001-04-04 19:27:01
Message-ID: 3ACB7584.F46EAD37@eCoNeed.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Browse pgsql-sql by date

  From Date Subject
Next Message Oliver Elphick 2001-04-04 20:14:56 Re: searching for dates
Previous Message Tom Lane 2001-04-04 18:55:30 Re: Need to do an ALTER TABLE.