如何获取给定时间的当周的星期天日期

oracle_cj

感觉bell的方法过于复杂

糗_蘑菇

10楼是错的，这个是没问题的

1. WITH T AS
   
2. (SELECT TRUNC(SYSDATE + ROWNUM) AS T FROM DUAL  CONNECT BY ROWNUM <= 100)
   
3. 
   
4. seLECT DECODE(TO_CHAR(T.T,'D'),1,TRUNC(T.T),TRUNC(T.T,'D')+7) FROM T
   

复制代码

arthurtangel

WITH T AS
(SELECT TRUNC(SYSDATE + ROWNUM) AS T FROM DUAL  CONNECT BY ROWNUM <= 10)
seLECT t.t,TRUNC(T.T,'D')+ case when to_char(T.T, 'D')=1 then 0 else 7 end x,to_char(t.t,'D') y FROM T