[프로그래머스] 3월에 태어난 여성 회원 목록 출력하기 - MySQL, Oracle

🔗 3월에 태어난 여성 회원 목록 출력하기

🦈 MySQL 🦈

✨ 방법1 : DATE_FORMAT ✨

SELECT MEMBER_ID
    , MEMBER_NAME
    , GENDER
    , DATE_FORMAT(DATE_OF_BIRTH, "%Y-%m-%d")
FROM MEMBER_PROFILE
WHERE GENDER = 'W'
    AND MONTH(DATE_OF_BIRTH) = 3
    AND TLNO IS NOT NULL
ORDER BY MEMBER_ID ASC;

 

🌟 방법2 : LIKE 🌟

SELECT MEMBER_ID
    , MEMBER_NAME
    , GENDER
    , DATE_FORMAT(DATE_OF_BIRTH, "%Y-%m-%d")
FROM MEMBER_PROFILE
WHERE GENDER = 'W'
    AND DATE_OF_BIRTH LIKE '%-03-%'
    AND TLNO IS NOT NULL
ORDER BY MEMBER_ID ASC;

 

⚡️ 방법3 : SUBSTR ⚡️

SELECT MEMBER_ID
    , MEMBER_NAME
    , GENDER
    , DATE_FORMAT(DATE_OF_BIRTH, "%Y-%m-%d")
FROM MEMBER_PROFILE
WHERE GENDER = 'W'
    AND SUBSTR(DATE_OF_BIRTH, 6, 2) = '03'
    AND TLNO IS NOT NULL
ORDER BY MEMBER_ID ASC;

 

⭕️ Oracle ⭕️

✨ 방법1 : TO_CHAR ✨

SELECT MEMBER_ID
    , MEMBER_NAME
    , GENDER
    , TO_CHAR(DATE_OF_BIRTH, 'YYYY-MM-DD') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE GENDER = 'W'
AND TO_CHAR(DATE_OF_BIRTH, 'MM') = '03'
AND TLNO IS NOT NULL
ORDER BY MEMBER_ID ASC;

 

🌟 방법2 : LIKE 🌟

SELECT MEMBER_ID
    , MEMBER_NAME
    , GENDER
    , TO_CHAR(DATE_OF_BIRTH, 'YYYY-MM-DD') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE GENDER = 'W'
AND TO_CHAR(DATE_OF_BIRTH, 'YYYY-MM-DD') LIKE '%-03-%'
AND TLNO IS NOT NULL
ORDER BY MEMBER_ID ASC;

 

⚡️ 방법3 : SUBSTR ⚡️

SELECT MEMBER_ID
    , MEMBER_NAME
    , GENDER
    , TO_CHAR(DATE_OF_BIRTH, 'YYYY-MM-DD') AS DATE_OF_BIRTH
FROM MEMBER_PROFILE
WHERE GENDER = 'W'
AND SUBSTR(TO_CHAR(DATE_OF_BIRTH, 'YYYY-MM-DD'), 6, 2) = '03'
AND TLNO IS NOT NULL
ORDER BY MEMBER_ID ASC;

 

 

 

---

날짜 형식의 데이터를 다룰 땐 방법1인 DATE_FORMAT과 TO_CHAR를 사용하는 것이 가독성 측면에서 더 좋다. LIKE와 SUBSTR은 직관적이지 않고 날짜 형식이 변경되면 코드도 수정해야 한다.