Oracle SQL查询-获取上周(周一至周六)的数据
问题描述：
我正在处理一个查询，该查询将显示上周(始终从星期一开始)从 COLUMNNAME ， TABLENAME .我还有一列带有日期的 adddate . 似乎不起作用...我该如何解决?
I'm working on a query that would show data added in last week (always beginning with Monday), from COLUMNNAME, TABLENAME. I also have a column with dates, adddate. It seems not to work... How would I fix it?
select COLUMNNAME
from TABLENAME
where adddate >= (TRUNC(adddate - 7 - (TRUNC (adddate)- TRUNC (adddedate, 'IW'))))
and adddate < (TRUNC(adddate - 7 - (TRUNC (adddate)- TRUNC (adddedate, 'IW'))))+6
答
我认为您的表达式需要其中的当前日期，例如:
I think your expression needs the current date in it somewhere, such as:
where adddate >= next_day(trunc(sysdate), 'MONDAY') - 14 and
adddate < next_day(trunc(sysdate), 'MONDAY') - 7