Skip to content

Instantly share code, notes, and snippets.

@zerobugs-oficial

zerobugs-oficial/sum_dates.sql

Created June 18, 2020 15:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zerobugs-oficial/4c8211f75d7903a5ae8a2b3c58ff701d to your computer and use it in GitHub Desktop.
Save zerobugs-oficial/4c8211f75d7903a5ae8a2b3c58ff701d to your computer and use it in GitHub Desktop.
Download ZIP
MySQL: Somar número de dias, meses ou anos a uma data - 1
Raw
sum_dates.sql
SELECT ADDDATE(coluna_data, INTERVAL 12 MONTH)
FROM tabela
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment