SQL syntax error on select between two dates

Question

I'm trying to get records which between two dates. Below is my query

select * from my_data 
where name = 'customer' AND 
(time between (('2021-03-24'::date - '1 month'::interval) AND '2021-03-24'::date))

However I'm getting a syntax error

ERROR:  syntax error at or near ")"
LINE 1: ...03-24'::date - '1 month'::interval) AND '2021-03-24'::date))
                                                                      ^

What is the correct way of writing the query to return rows 1 month older than a given date?

Gordon Linoff · Accepted Answer · 2021-04-18 19:16:31Z

1

You can drop the parentheses:

select *
from my_data 
where name = 'customer' AND 
      time between '2021-03-24'::date - '1 month'::interval AND '2021-03-24'::date;

The specific issue is that the range for between does not accept parens.

answered Apr 18, 2021 at 19:16

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

SQL syntax error on select between two dates

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