mysql 날짜에서 요일 얻어내기

간단하게 id 와 date 타입 컬럼만 있는 테이블

 

DAYOFWEEK 명령어로 요일을 같이 출력 합니다

SELECT 
    CASE
        WHEN DAYOFWEEK(access_time) = 1 THEN 1
        ELSE 0
    END AS isSunday,
    CASE
        WHEN DAYOFWEEK(access_time) = 2 THEN 1
        ELSE 0
    END AS isMonday,
        CASE
        WHEN DAYOFWEEK(access_time) = 3 THEN 1
        ELSE 0
    END AS isTuesday,
        CASE
        WHEN DAYOFWEEK(access_time) = 4 THEN 1
        ELSE 0
    END AS isWednesday,
        CASE
        WHEN DAYOFWEEK(access_time) = 5 THEN 1
        ELSE 0
    END AS isThursday,
        CASE
        WHEN DAYOFWEEK(access_time) = 6 THEN 1
        ELSE 0
    END AS isFriday,
        CASE
        WHEN DAYOFWEEK(access_time) = 7 THEN 1
        ELSE 0
    END AS isSaturday,
    id,
    access_time
FROM test_table