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天
oracle时间限定范围,三十天之内,三天之内
最新推荐文章于 2024-05-14 00:49:36 发布