php - 从数据库数据计算当前年份月份的经验

Question

我有包含年份和月份的数据库

       year  month   createdate
        1      2     2017-04-12 10:36:25

我想计算从创建日期的年月到现在(当年月)的经验

Answer 1

您可以使用TIMESTAMPDIFF功能。

SELECT 
    TIMESTAMPDIFF(YEAR, created_date, now()) as year, 
    TIMESTAMPDIFF(MONTH, created_date, now()) - TIMESTAMPDIFF(YEAR, created_date, now()) * 12 as month
FROM your_table;