SQL
[mySQL]DATE_FORMAT
메냑우유
2019. 3. 15. 15:56
mySQL 날짜형
DATE_FORMAT(date,format)
-> DATE_FORMAT(NOW(), '%Y-%m') -- '2019-03'
-> DATE_FORMAT(NOW(), '%Y-%m-%d') -- '2019-03-15'
-> DATE_FORMAT(NOW(), '%Y-%m-%d %T') -- 2019-03-15 15:53:53
SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %T') FROM dual
http://www.mysqltutorial.org/mysql-date_format/