[mysql/oracle] 3월에 태어난 여성 회원 목록 출력하기

문제

 

결과

 

mysql

SELECT member_id, member_name, gender
       , date_format(date_of_birth, '%Y-%m-%d') date_of_birth
from member_profile
where gender = 'W' 
      and month(date_of_birth) = '03' 
      and tlno is not null
order by member_id

 

oracle

SELECT member_id, member_name, gender, to_char(date_of_birth, 'yyyy-mm-dd') 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