所以，我有即將到期的員工合同資料，我想顯示今天月份和未來 3 個月日期的員工資料。我試過使用 DATEADD 或 DATE_ADD 但它仍然不起作用。請幫忙
這是我的查詢：
SELECT a.fullname, a.employee_id, a.id_number, b.date_contract_from, b.date_contract_to AS expired,
b.is_current, b.is_deleted, b.employment_status
FROM hr_employees a
INNER JOIN hr_employee_jobs b
ON a.id = b.employee
WHERE b.date_contract_to >= NOW()
AND b.employment_status IN ('1', '2')
AND b.is_current = 1
AND b.is_deleted = 0 AND a.is_deleted = 0
GROUP BY b.employee
ORDER BY b.date_contract_to ASC
這是它的外觀示例。因此，不應出現 4 月的到期日。
這是查詢視圖
uj5u.com熱心網友回復：
您可以像這樣在 Query 和DATE_ADD函式之間使用日期。
SELECT a.fullname, a.employee_id, a.id_number, b.date_contract_from, b.date_contract_to AS expired,
b.is_current, b.is_deleted, b.employment_status
FROM hr_employees a
INNER JOIN hr_employee_jobs b
ON a.id = b.employee
WHERE b.date_contract_to BETWEEN now() AND DATE_ADD(now(), INTERVAL 3 MONTH)
AND b.employment_status IN ('1', '2')
AND b.is_current = 1
AND b.is_deleted = 0 AND a.is_deleted = 0
GROUP BY b.employee
ORDER BY b.date_contract_to ASC
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/403874.html
標籤：