MYSQL Query Date Between

Question

What is wrong with this query

select  a.TESTDATE  from testr a,XREFRTGTE b where a.id = b.id and a.TESTDATE between BETWEEN STR_TO_DATE('2011-05-26 12:22:33','YYYY-MM-DD HH:MM:SS') AND STR_TO_DATE('2011-06-02 12:22:33','YYYY-MM-DD HH:MM:SS') limit 200

Please help

I see two between and I don't know why you're using str_to_date if you have to datetime fields and not strings. — Nicola Cossu
– Nicola Cossu, Commented Jun 2, 2011 at 7:09

codaddict · Accepted Answer · 2011-06-02 07:08:26Z

2

I can see two between used in the query:

... between BETWEEN ...

Try dropping one.

answered Jun 2, 2011 at 7:08

codaddict

457k83 gold badges501 silver badges537 bronze badges

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

Collectives™ on Stack Overflow

MYSQL Query Date Between

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