SQL代码:
SELECT b.day,b.XINGQI FROM
(select a.day,to_char(a.day,'day') as xingqi, 1 as flag
from
(SELECT TO_DATE('20160101', 'YYYY-MM-DD') + LEVEL - 1 DAY
FROM DUAL
CONNECT BY TO_DATE('20160101', 'YYYY-MM-DD') + LEVEL - 1 <=
TO_DATE('20161226', 'YYYY-MM-DD')
) a
) b
WHERE b.XINGQI='monday '
where条件语句中XINGQI 根据数据库语言的不同,有些数据库出来的是英文,有些是中文,需要对应修改即可