Skip to content

Instantly share code, notes, and snippets.

@TaffarelXavier

TaffarelXavier/Shows users who are completing their year.md

Last active July 13, 2022 15:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save TaffarelXavier/f4f1faf80ecde564ff1f67d6613e1564 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save TaffarelXavier/f4f1faf80ecde564ff1f67d6613e1564 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Shows users who are completing their year.md

EN: Shows all users who are completing their year on the current date
PT_BR: Mostra todos os usuários que estão completando ano na data atual.
ES: Muestra todos los usuarios que están completando su año en la fecha actual

SELECT age, DATE_FORMAT(age, "%d-%m") ageMonth FROM users
HAVING ageMonth = DATE_FORMAT(CURRENT_DATE, "%d-%m");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment