SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01'); : TIMESTAMPDIFF : Date Time Functions MySQL TUTORIALS

SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01');

Related Scripts with Example Source Code in same category :
• TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)
• SELECT TIMESTAMPDIFF(FRAC_SECOND,'2003-02-01','2003-05-01');
• SELECT TIMESTAMPDIFF(SECOND,'2003-02-01','2003-05-01');
• SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01');
• SELECT TIMESTAMPDIFF(HOUR,'2003-02-01','2003-05-01');
• SELECT TIMESTAMPDIFF(DAY,'2003-02-01','2003-05-01');
• SELECT TIMESTAMPDIFF(WEEK,'2003-02-01','2003-05-01');
• SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');
• SELECT TIMESTAMPDIFF(QUARTER,'2003-02-01','2003-05-01');
• SELECT TIMESTAMPDIFF(YEAR,'2003-02-01','2003-05-01');

Leave a Comment / Note

Name (required)

email (will not be published) (required)

Website

Vérification Refresh		Enter code
Verification is used to prevent unwanted posts (spam). .