searching for dates

Поиск
Список
Период
Сортировка
От Birgit Jansen
Тема searching for dates
Дата
Msg-id 3ACB7584.F46EAD37@eCoNeed.com
обсуждение исходный текст
Ответы Re: searching for dates  ("Oliver Elphick" <olly@lfix.co.uk>)
Список 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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Need to do an ALTER TABLE.
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: Re: searching for dates