IT/DB
특정해 주말만 구하는 쿼리...
iezs
2012. 1. 4. 18:24
http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=183005
SELECT TO_CHAR(yyyymmdd, 'YYYYMMDD') yyyymmdd
FROM (
SELECT start_date + level - 1 yyyymmdd
FROM (SELECT TO_DATE('20110101', 'YYYYMMDD') start_date, TO_DATE('20111231', 'YYYYMMDD') end_date FROM DUAL)
CONNECT BY level <= end_date - start_date + 1
)
WHERE TO_CHAR(yyyymmdd, 'd') in (1,7)
SELECT TO_CHAR(yyyymmdd, 'YYYYMMDD') yyyymmdd
FROM (
SELECT start_date + level - 1 yyyymmdd
FROM (SELECT TO_DATE('20110101', 'YYYYMMDD') start_date, TO_DATE('20111231', 'YYYYMMDD') end_date FROM DUAL)
CONNECT BY level <= end_date - start_date + 1
)
WHERE TO_CHAR(yyyymmdd, 'd') in (1,7)