mysql获取当前日期与合同到期日期差小于1个月的非离职员工

sql：

SELECT
	DATEDIFF(CURDATE(), a.expire_date) AS diff_daoqi_date
FROM
	`ys_admin_user` as a
WHERE 1
AND a.if_del = 0
AND (
	(
		DATEDIFF(CURDATE(), a.expire_date) < 30
		AND DATEDIFF(CURDATE(), a.expire_date) >= 0
	)
	OR (
		DATEDIFF(CURDATE(), a.expire_date) < 0
		AND DATEDIFF(CURDATE(), a.expire_date) > - 30
	)
);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

数据：