MySQL ) 이번주 월요일부터 일요일까지 날짜 구하기

오늘이 끼어있는 이번주 월~일의 날짜 구하기

 

쿼리

SELECT
	ADDDATE( CURDATE(), - WEEKDAY(CURDATE()) + 0 ) AS MONDAY,
	ADDDATE( CURDATE(), - WEEKDAY(CURDATE()) + 1 ) AS TUESDAY,
	ADDDATE( CURDATE(), - WEEKDAY(CURDATE()) + 2 ) AS WEDNESDAY,
	ADDDATE( CURDATE(), - WEEKDAY(CURDATE()) + 3 ) AS THURSDAY,
	ADDDATE( CURDATE(), - WEEKDAY(CURDATE()) + 4 ) AS FRIDAY,
	ADDDATE( CURDATE(), - WEEKDAY(CURDATE()) + 5 ) AS SATURDAY,
	ADDDATE( CURDATE(), - WEEKDAY(CURDATE()) + 6 ) AS SUNDAY
FROM
	DUAL

---

 

 

예시

통계에서 이번주의 갯수를 구할거면

SELECT
    count(*)
FROM
    TBexamp
WHERE
    date_format(날짜컬럼,'%Y-%m-%d')
    BETWEEN
        (SELECT ADDDATE(CURDATE(), - WEEKDAY(CURDATE()) + 0 ))
    AND
        (SELECT ADDDATE(CURDATE(), - WEEKDAY(CURDATE()) + 6 ));