Databases Reporting with SQL Date and Time Functions Formatting Dates and Times

Stephanie Albright
Stephanie Albright
5,124 Points

Can't find my syntax error.

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

I can't figure out what my syntax error is, help please.

2 Answers

KRIS NIKOLAISEN
KRIS NIKOLAISEN
52,852 Points

You are selecting more columns than asked for by the challenge (and missing a comma). If you reduce what you have to just what is being asked you'll pass:

SELECT title, STRFTIME("%m/%Y", date_released) AS month_year_released FROM movies;
Stephanie Albright
Stephanie Albright
5,124 Points

I knew it was something dumb I was doing! Thank you so much!