Getting a range of dates for PostgreSQL

Question

I would like to get the entries for a range of dates, using PostgreSQL.

For example...

beginyear       endyear       name
---------       -------       -----
950             1100          jason
1300            1400          andrew

I would like to get all people who lived in 1050. Could someone please help me to write this query.

Mike Sherrill 'Cat Recall' · Accepted Answer · 2011-02-06 08:20:04Z

5

select name
from yourtable
where 1050 between beginyear and endyear;

answered Feb 6, 2011 at 8:20

96.6k20 gold badges134 silver badges195 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kmkaplan · Accepted Answer · 2011-02-06 08:16:36Z

0

SELECT * FROM mytable
 WHERE beginyear <= 1050 AND 1050 <= endyear

answered Feb 6, 2011 at 8:16

kmkaplan

19k4 gold badges55 silver badges65 bronze badges