oracle时间限定范围，三十天之内，三天之内

select
    'last_30days' as time_range,
    sum(exit_time)/count(exit_time) as avg_clr_time
from
    clr.dws_dcon_average_cce_m
    WHERE TRUNC(D_RG_TIME) >= TRUNC(SYSDATE-30);--从本地时间往前三十天

--TRUNC(D_RG_TIME) >= TRUNC(SYSDATE-3);--从本地时间往前三天
--TRUNC(D_RG_TIME) >= TRUNC(SYSDATE-365);--从本地时间往前365天