[SQL] 날짜 포맷, 오름차순, 내림차순

SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD, '%Y-%m-%d') 
FROM DOCTOR WHERE MCDP_CD='CS' OR MCDP_CD='GS' 
ORDER BY HIRE_YMD DESC, DR_NAME ASC;

 

DATE_FORMAT(HIRE_YMD, '%Y-%m-%d') 
내림차순순 DESC, 오름차순 ASC;