test/datetime.sql

   1 SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');
   2 SELECT TIMESTAMPDIFF(YEAR,'2002-05-01',@x);
   3 SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55');
   4 SELECT TIMESTAMPDIFF(MONTH, '2019-11-12', CURRENT_TIMESTAMP())
   5 -- not allowed
   6 -- SELECT TIMESTAMPDIFF(@MONTH,'2003-02-01','2003-05-01');