Extracting rows between 2 dates using SQL

Question

id    date       temp       prcp
1   2015-01-01  -27.18      0
1   2015-01-02  -25.9       1.03
1   2015-01-03  -17.89      9.44
1   2015-01-04  -17.89      9.44
1   2015-01-05  -17.89      9.44

SELECT * FROM tbl WHERE id=1 and date between '2015-01-03' and '2015-01-05'

How do I fix the SQL query above? I am trying to extract all rows between the 2 dates '2015-01-03' and '2015-01-05'

Did you mean date >= '2015-01-03' and date <= '2015-01-05'? — aghast
– aghast, Commented Mar 31, 2017 at 5:22
that works! If you put it as answer, I will accept. Also any ideas why between does not work? — user308827
– user308827, Commented Mar 31, 2017 at 5:24
I don't know why it doesn't work. Does your underlying sql support between? — aghast
– aghast, Commented Mar 31, 2017 at 5:28
I saw an example of a complex query where they put the BETWEEN expression in parens, to separate BETWEEN ... AND from logical AND: SELECT ... WHERE (x BETWEEN v1 AND v2) AND other stuff. Maybe put your between in parens? — aghast
– aghast, Commented Mar 31, 2017 at 5:37

aghast · Accepted Answer · 2017-03-31 05:24:45Z

2

Did you mean date >= '2015-01-03' and date <= '2015-01-05'?

answered Mar 31, 2017 at 5:24

aghast

15.4k4 gold badges31 silver badges58 bronze badges

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

1 Comment

user330315 Over a year ago

Which is exactly the same as date between '2015-01-03' and '2015-01-05'

Ben · Accepted Answer · 2017-03-31 06:06:29Z

2

I think "date" as the column name is a bad idea. Try quoting them with double quote.

answered Mar 31, 2017 at 6:06

Ben

1,3511 gold badge20 silver badges33 bronze badges

1 Comment

Ben Over a year ago

postgresql.org/docs/current/static/… "In Table C-1 in the column for PostgreSQL ... If not so marked, a reserved key word is only allowed as an "AS" column label name." and date is not marked.

Collectives™ on Stack Overflow

Extracting rows between 2 dates using SQL

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related