查询时间点所在周一到周日的:
select * from yourtable where TIME BETWEEN TRUNC(TIME,'IW') AND TRUNC(TIME) + 7
查询时间点所在周日到下周六的:
select * from yourtable where TIME BETWEEN TRUNC(TIME,'WW') AND TRUNC(TIME) + 7
说明:
TRUNC(TIME,'IW') 指定时间的本周一所在日期
TRUNC(TIME,'WW') 指定时间的本周一的前一天(周日)所在日期
select * from yourtable where TIME BETWEEN TRUNC(TIME,'IW') AND TRUNC(TIME) + 7
查询时间点所在周日到下周六的:
select * from yourtable where TIME BETWEEN TRUNC(TIME,'WW') AND TRUNC(TIME) + 7
说明:
TRUNC(TIME,'IW') 指定时间的本周一所在日期
TRUNC(TIME,'WW') 指定时间的本周一的前一天(周日)所在日期