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 Reporting with SQL Date and Time Functions Formatting Dates and Times

Rachel Waybill
Rachel Waybill
1,393 Points

I don't understand what this is supposed to be.

I don't understand what this is supposed to be.

1 Answer

Travis Alstrand
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Data Analysis Techdegree Graduate 49,443 Points

Hey Rachel Waybill 👋

Do you mean the challenge as a whole?

If so, I'd recap on the previous video Formatting Dates for Reporting. He goes over everything you need there.

You'll want to grab the title and use STRFTIME() (string format time) on the date_released value and give that new date an alias of month_year_released. Remember, the formatting for the month should be %m and the year %Y.

I hope this helps!

Rachel Waybill
Rachel Waybill
1,393 Points

thank you! I figured it out, just getting frustrated. I was not putting date_released in there where it went.