对于这种情况,您只需要向右移TRUNC:@H_502_1@
WHERE date_occured >= TRUNC(CURRENT_DATE - 30)
为什么?因为如果TRUNC(date_occured)晚于TRUNC(CURRENT_DATE-30),那么TRUNC(date_occured)之后的任何时间也必定晚于TRUNC(CURRENT_DATE-30)。@H_502_1@
显然,date_occured> = TRUNC(date_occured)总是正确的(考虑一下)。@H_502_1@
逻辑说,如果A> = B且B> = C,则得出A> = C@H_502_1@
现在替换为:@H_502_1@