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

suyesh bhandari
suyesh bhandari
15,328 Points
Posted by suyesh bhandari
suyesh bhandari
15,328 Points

What am i doing wrong here.

Challenge Task 2 of 2 We're back in our sports team database with the results table. The columns are id, home_team, home_score, away_team, away_score and played_on.

There are 30 days in September. Find all the games played in the results table in September 2015.

My Code

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

Error i am getting

Bummer! You're missing the value of "2015-09-01"

1 Answer

Sigurd Melsom
Sigurd Melsom
6,107 Points
Sigurd Melsom
Sigurd Melsom
6,107 Points

Use single quotes instead of double: SELECT * FROM results WHERE played_on BETWEEN '2017-09-01' AND '2017-09-30';

suyesh bhandari
suyesh bhandari
15,328 Points
suyesh bhandari
suyesh bhandari
15,328 Points

That worked. Thanks.

So when should i use double vs single quotes?