BETWEEN trunc(sysdate-to_char(sysdate, 'D ')+1) and trunc(sysdate-to_char(sysdate, 'D ')+1)-7
oracle 查询上周记录
最新推荐文章于 2022-09-06 17:16:32 发布
BETWEEN trunc(sysdate-to_char(sysdate, 'D ')+1) and trunc(sysdate-to_char(sysdate, 'D ')+1)-7