2020년 1월 2일 IT - Oracle 주차 확인 Query
SELECT TO_CHAR (BASE_MON + LEVEL - 1, 'YYYYMMDD') TODAY, TO_CHAR (BASE_MON + LEVEL - 1, 'dd') DD, TO_CHAR (BASE_MON + LEVEL - 1, 'd') D, CASE WHEN TO_CHAR (BASE_MON + LEVEL - 1, 'd') = 7 THEN '토' WHEN TO_CHAR (BASE_MON + LEVEL - 1, 'd') = 6 THEN '금' WHEN TO_CHAR (BASE_MON + LEVEL - 1, 'd') = 5 THEN '목' WHEN TO_CHAR (BASE_MON + LEVEL - 1, 'd') = 4 THEN '수' WHEN TO_CHAR (BASE_MON + LEVEL - 1, 'd')..
IT
2020. 1. 2. 10:42
