Unnamed

mysql> select timestampdiff(DAY,'2005-05-01','2007-10-10');+----------------------------------------------+| timestampdiff(DAY,'2005-05-01','2007-10-10') |+----------------------------------------------+|                                          892 |+----------------------------------------------+1 row in set (0.00 sec)mysql> select timestampdiff(MONTH,'2005-05-01','2007-10-10');+------------------------------------------------+| timestampdiff(MONTH,'2005-05-01','2007-10-10') |+------------------------------------------------+|                                             29 |+------------------------------------------------+1 row in set (0.00 sec)mysql> select timestampdiff(YEAR,'2005-05-01','2007-10-10');+-----------------------------------------------+| timestampdiff(YEAR,'2005-05-01','2007-10-10') |+-----------------------------------------------+|                                             2 |+-----------------------------------------------+1 row in set (0.00 sec)mysql>