Can I search if an interval is between another interval?

Question

I need to search if a date, or any day 30 days from that date is between an interval. Is that achievable somehow using postgresql?

Answer 1

You could simply check for interval overlaps:

SELECT daterange(current_date, current_date + 31) && '[2022-01-01,2022-01-31]';

There is also tsrange for ranges of timestamp and tstzrange for ranges of timestamp with time zone.