1、場景:定時任務,每天定時跑,擷取前三天的資料: 日常中用到的sql語句 select * from PS2UMU_EMPLOYEE_VW where to_days(now()) - to_days(時間字段) <= 3;