SQL:UPDATE [期间表]
SET [期间截止时间] = CASE
WHEN MONTH([期间截止时间]) IN (6, 12) THEN
CASE
WHEN MONTH([期间截止时间]) = 6 THEN EOMONTH([期间截止时间], 0)
WHEN MONTH([期间截止时间]) = 12 THEN EOMONTH([期间截止时间], 0)
END
ELSE [期间截止时间]
END
WHERE MONTH([期间截止时间]) IN (6, 12);
我试了下 但是计划任务测试返回:SQLite Error 1: 'no such function: EOMONTH'. |