MySQL query with date

Question

I have following query, but it gives me errors, if anyone could give me a hint, would be awesome.

SELECT tblinvoices.*,companyname FROM tblinvoices INNER JOIN tblclients 
ON tblclients.id=tblinvoices.clientid 
WHERE 1=1 AND date between '20111201' to '20111208'

The error message is:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TO '20111208''

I've edited the question and added the error message for you. Next time try not to be so lazy. — Álvaro González
– Álvaro González, Commented Dec 10, 2011 at 18:02

ypercubeᵀᴹ · Accepted Answer · 2011-12-10 20:37:21Z

2

use AND instead of TO in the BETWEEN command.

SELECT tblinvoices.*,companyname FROM tblinvoices INNER JOIN tblclients 
ON tblclients.id=tblinvoices.clientid 
WHERE 1=1 AND date between '20111201' AND '20111208'

edited Dec 10, 2011 at 20:37

ypercubeᵀᴹ

116k19 gold badges181 silver badges249 bronze badges

answered Dec 10, 2011 at 16:29

Alex

35.7k20 gold badges115 silver badges202 bronze badges

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

Comments

user879760 · Accepted Answer · 2011-12-10 16:29:14Z

0

I am pretty sure is the word TO, it should be:

SELECT tblinvoices.*,companyname FROM tblinvoices INNER JOIN tblclients ON tblclients.id=tblinvoices.clientid WHERE 1=1 AND date between '20111201' AND '20111208'

answered Dec 10, 2011 at 16:29

user879760

Comments

Andreas Wederbrand · Accepted Answer · 2011-12-10 16:29:57Z

0

If companyname is from tblinvoices it should work, otherwise you need to check where companyname comes from. And the syntax for between is like this

date between '20111201' and '20111208'

answered Dec 10, 2011 at 16:29

Andreas Wederbrand

40.5k12 gold badges71 silver badges82 bronze badges

Collectives™ on Stack Overflow

MySQL query with date

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related