Oracle SQL #02 주중/주말 (CASE)

1. 단순 CASE

SELECT 컬럼1
CASE WHEN TRIM(TO_CHAR(컬럼2,’DAY’))
IN (‘토요일’,’일요일’)
THEN ‘주말’
ELSE ‘주중’ END “주중/주말”
FROM 테이블;

2. 검색 CASE

SELECT 컬럼1
CASE WHEN TO_CHAR(컬럼2,’DAY’)
BETWEEN ‘토요일’ AND ‘일요일’
THEN ‘주말’
ELSE ‘주중’ END “주중/주말”
FROM 테이블;