CODEWITHSUNDEEP
postgresqldate-range
diesel
diesel

Reputation:

Getting a range of dates for PostgreSQL

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.

Upvotes: 0

Views: 396

Answers (2)

Mike Sherrill 'Cat Recall'
Mike Sherrill 'Cat Recall'

Reputation: 95761

select name
from yourtable
where 1050 between beginyear and endyear;

Upvotes: 5

kmkaplan
kmkaplan

Reputation: 18970

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

Upvotes: 0

Related Questions