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 trialArush Sharma
2,513 PointsThis is the error message when I try to execute my query - " Your query retrieve the dates in the correct format (%m/%Y)
In a movies database we have a movies table. It has the columns of id, title, date_released and genre.
Write a query that returns the title first and the month and year it was released alias as month_year_released. Dates should look like "04/1983" for April 1983.
Can you please explain the solution?
devina christabela
12,526 Pointsdevina christabela
12,526 PointsAs the challenge said, you have 4 columns
id
,title
,date_released
, andgenre
title
and thedate_released
from the table moviesdate_released
column asmonth_year_released
date_released
with format month/year, syntax clue onDATE_FORMAT
,%m
is to get the month value with 2 digit like01
, and%Y
to get year value with 4 digit like2020