How to select a date interval in postgresql query?

Question

I have query like this:

select d.id from days as d JOIN tv_programs AS t ON (d.tv_program_id = t.id) WHERE d.date=? AND t.type=0 ORDER BY d.date, t.date DESC OFFSET 1;

it returns data for 1 selected date (type Date), but i want to get values from startDate to endDate, for example, i want to do it using one query which do something like that:

select d.id from days as d JOIN tv_programs AS t ON (d.tv_program_id = t.id) WHERE d.date='2011-09-01' AND t.type=0 ORDER BY d.date, t.date DESC OFFSET 1;
select d.id from days as d JOIN tv_programs AS t ON (d.tv_program_id = t.id) WHERE d.date='2011-09-02' AND t.type=0 ORDER BY d.date, t.date DESC OFFSET 1;
select d.id from days as d JOIN tv_programs AS t ON (d.tv_program_id = t.id) WHERE d.date='2011-09-03' AND t.type=0 ORDER BY d.date, t.date DESC OFFSET 1;

It's possible?

yes... what type is d.date ?

Yahia
– Yahia

2011-09-14 08:51:00 +00:00
Commented Sep 14, 2011 at 8:51 — Yahia
– Yahia, Commented Sep 14, 2011 at 8:51

maxmc · Accepted Answer · 2011-09-14 10:06:35Z

4

... where d.date between '2011-09-01' and '2011-09-04' should work.

answered Sep 14, 2011 at 10:06

maxmc

4,2161 gold badge27 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to select a date interval in postgresql query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related