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,435 Points
Posted by Rachel Waybill
Rachel Waybill
1,435 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
Treehouse Project Reviewer
Travis Alstrand
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Treehouse Project Reviewer

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,435 Points
Rachel Waybill
Rachel Waybill
1,435 Points

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