BETWEEN trunc(sysdate-to_char(sysdate, 'D ')+1) and trunc(sysdate-to_char(sysdate, 'D ')+1)-7
oracle 查询上周记录
最新推荐文章于 2024-07-24 17:02:05 发布
BETWEEN trunc(sysdate-to_char(sysdate, 'D ')+1) and trunc(sysdate-to_char(sysdate, 'D ')+1)-7