날짜구하기
-
MySQL ) 이번주 월요일부터 일요일까지 날짜 구하기IT/DB 2019. 5. 29. 08:26
오늘이 끼어있는 이번주 월~일의 날짜 구하기 쿼리 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..