Compare array between interval SQL

Question

I have an array which has 3 dates : 2014-11-20 2014-11-25 2014-11-30

and I need to compare if those date are between 2014-11-01 AND 2014-11-30

I am trying to unnest the array and then compare between those dates but it is not working.

Any ideas?

user_0 · Accepted Answer · 2014-12-15 13:53:55Z

1

HERE you are a working example, tested on postgresql 9.3:

SELECT * FROM UNNEST(ARRAY['20141120', '20141125', '20141130']::date[]) AS mycolumn
WHERE mycolumn > '20141101'
AND mycolumn < '20141130';

answered Dec 15, 2014 at 13:53

user_0

3,38323 silver badges38 bronze badges

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

2 Comments

> and < is not the same as BETWEEN, you need >= and <= or just BETWEEN

What do you need to join?