John Grillo30,215 Points
STRFTIME Task challenge
I'm doing the SQL reporting challenge and seem to be stuck on it. I've definitely done this before in my job, but for some reason I'm having a hard time with it. The challenge says that I'm formatting it to the correct time but after checking the SQL, MySQL and SQLite documentation, I can't seem to see what it is that I'm not getting.
Anyway, would appreciate a spot of advice.
SELECT title , STRFTIME("%M%Y", date_released) AS 'month_year_released' FROM movies
John, you're very close. It makes a difference whether you use m or M. This works fine:
SELECT title, STRFTIME("%m/%Y", date_released) AS 'month_year_released' FROM movies
That's interesting. Why It doesn't matter if we use y instead of Y?