Algorithm/SQL

[SQL][프로그래머스] DATETIME에서 DATE로 형 변환

융무 2020. 6. 15. 18:50

SELECT ANIMAL_ID, NAME, DATE_FORMAT(datetime,'%Y-%m-%d') AS '날짜'
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;