SQL Challenge Project

Hi Everyone,
I’m working on Data Science Path, SQL Challenge Projects #8: One of the members of the marketing team had an idea of calculating how old users were when they signed up.
Below is my code using DATEDIFF, I’m not sure why it doesn’t work. Any input is appreciated.

SELECT email,

  birthday,

  created_at,

  FLOOR(DATEDIFF(DAY, birthday, created_at) / 365.25) AS Age

FROM users

Welcome to the forums.

Have you seen this thread? Specifically a response from @coffeencake :

SELECT email, Date(‘now’) - birthday as age FROM users