Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Posted by xl
xl
1,970 Points

SELECT * FROM results WHERE played_on BETWEEN 2015-09-01 AND 2015-09-30; it says i am missing the value of 2015-09-01?

SELECT * FROM results WHERE played_on BETWEEN 2015-09-01 AND 2015-09-30; it says I typed this command and it's telling me i am missing the value of 2015-09-01? i tried to change the date to 2015-08-31, it gives me the same error :( help please, thank you <3

Jason Anders
Jason Anders
Treehouse Moderator 145,860 Points
Jason Anders
Jason Anders
Treehouse Moderator 145,860 Points

If you could include a direct link to the challenge you are having problems with, it will greatly help others to be able to assist you. :) :dizzy:

2 Answers

Steven Parker
Steven Parker
231,271 Points
Steven Parker
Steven Parker
231,271 Points

It looks like you forgot to enclose your dates in quotes.

Try it like this:

SELECT * FROM results WHERE played_on BETWEEN '2015-09-01' AND '2015-09-30';
xl
xl
1,970 Points

Thanks Steven!

doughymas
PLUS
doughymas
Courses Plus Student 1,331 Points
doughymas
doughymas
Courses Plus Student 1,331 Points

SELECT * FROM results WHERE played_on BETWEEN "2015-09-01" AND "2015-09-30";