Select TO_CHAR (t.d, 'YYYY-MM-DD') as sdate,TO_CHAR (t.d, 'day') as Weeks
FROM (Select (TRUNC (sysdate, 'WW') + ROWNUM -1) d
FROM dual
Where ROWNUM < 7) t
Where TO_CHAR (t.d, 'WW') = TO_CHAR (sysdate, 'WW') order by sdate
获取当前日期对应是星期几
最新推荐文章于 2022-08-11 16:43:24 发布