要查出本月数据sql

SELECT *,FROM_UNIXTIME(ADDTIME,'%y-%m-%d') AS TIME FROM tp_users WHERE MONTH(FROM_UNIXTIME(ADDTIME,'%y-%m-%d')) = MONTH(NOW())

结果如下