Re: [SQL] searching for dates

2001-04-04 Thread Oliver Elphick
Birgit Jansen wrote: >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

[SQL] searching for dates

2001-04-04 Thread Birgit Jansen
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 w