计算从数据库数据到本年度月份的经验

Question

Iam有包含列year和month的数据库

       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;