MySQL DATE 날짜 형식 바꾸기

DATE_FORMAT(date, format_mask)

// 날짜 형식 "yyyy-mm-dd hh:mi:ss"
SELECT 
    DATE_FORMAT(UPD_DATE, '%Y-%m-%d %H:%i:%s') 
FROM MEMBER 
ORDER BY UPD_DATE 
DESC LIMIT 1
 
// 날짜 형식 "yyyy mm/dd hh:mi:ss AM/PM"
SELECT 
    DATE_FORMAT(UPD_DATE, "%Y %c/%e %r") 
FROM MEMBER 
ORDER BY UPD_DATE 
DESC LIMIT 1

DATE_FORMAT(NOW(),'%b %d %Y %h:%i %p')
DATE_FORMAT(NOW(),'%m-%d-%Y')
DATE_FORMAT(NOW(),'%d %b %y')
DATE_FORMAT(NOW(),'%d %b %Y %T:%f')