56,678
社区成员
发帖
与我相关
我的任务
分享
UPDATE Loan
(SET Fine=(Date_ret-Date_due)*0.20
WHERE Fine is NULL AND Date_ret>Date_due)
AND
(SET Fine=(SYSDATE()-Date_due)*0.20
WHERE Fine is NULL AND Date_ret is NULL);
UPDATE Loan
SET Fine=(Date_ret-Date_due)*0.20
WHERE Fine is NULL AND Date_ret is NOT NULL AND Date_ret>Date_due;
UPDATE Loan
SET Fine=(SYSDATE()-Date_due)*0.20
WHERE Fine is NULL AND Date_ret is NULL AND SYSDATE()>Date_due;
update loan
set Fine=Datediff(IFNULL(Date_ret,SYSDATE()),Date_due)*0.2
where IFNULL(Date_ret,SYSDATE())>Date_due
And Fine Is null