签到日期出现错误, 工具类判断都是正数,总是理论课日期, 需要修改成与场次日期比较, 取小的, 场次日期是取3场中最小的,然后与之比较。
UPDATE
SIM_SUITE E
SET e.checkin_date =
(
--SELECT MIN(T.S_DATE)
SELECT CASE WHEN MIN(T.S_DATE) > e.checkin_date THEN e.checkin_date ELSE MIN(T.S_DATE) END AS d1
FROM sim_training_sim T
WHERE T.SUITE_ID = E.SUITE_ID)
WHERE E.AC_TYPE_CODE = 12
AND E.FIXED_YEAR = '2013上半年'
AND E.BENCH_MONTH = 2
;