[Programmers][SQL] DATETIME에서 DATE로 형 변환 (59414번) - MySQL Solution

문제

• https://programmers.co.kr/learn/courses/30/lessons/59414

---

Solution

SELECT ANIMAL_ID, NAME, DATE_FORMAT(DATETIME, '%Y-%m-%d')
FROM ANIMAL_INS
ORDER BY ANIMAL_ID