Skip to content

Instantly share code, notes, and snippets.

@zerobugs-oficial

zerobugs-oficial/diff_dates.sql

Created June 18, 2020 15:54
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/aef00989e6e1ec1dacdf4419a64395a6 to your computer and use it in GitHub Desktop.
Save zerobugs-oficial/aef00989e6e1ec1dacdf4419a64395a6 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL: Calcular quantidade de dias, meses ou anos entre duas datas
Raw
diff_dates.sql
SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');
SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01');
SELECT TIMESTAMPDIFF(DAY,'2003-02-01','2003-05-01');
SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment