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

Prem Yadav
Prem Yadav
7,346 Points
Posted by Prem Yadav
Prem Yadav
7,346 Points

Not able to solve this query.........

Hi there In this query i have selected title and used STRFTIME method as it asked but still throwing error. please help

Steven Parker
Steven Parker
231,128 Points
Steven Parker
Steven Parker
231,128 Points

To facilitate answering your question, please show your complete code and provide a link to the course page.

2 Answers

Prem Yadav
Prem Yadav
7,346 Points
Prem Yadav
Prem Yadav
7,346 Points

SELECT title, STRFTIME("%m/%y", date_released) AS month_year_released FROM movies;

Steven Parker
Steven Parker
231,128 Points
Steven Parker
Steven Parker
231,128 Points

That helps, but can you also point me to the course page you're working with?

Katie Wood
Katie Wood
19,141 Points
Katie Wood
Katie Wood
19,141 Points

Hi there,

Based on the code you posted, you might want to try capitalizing the 'Y' in your strftime function - there may not be an option for year that uses a lowercase letter.

Try something like this:

SELECT title, STRFTIME("%m/%Y", date_released) AS month_year_released FROM movies;

If that doesn't work, let me know which course you're on so I can make sure I test in the correct workspace.