[MYSQL] 날짜 치환 (오라클 TO_CHAR, TO_DATE)
SELECT DATE_FORMAT(‘2013-09-27’, ‘%Y-%m-%d %H:%i:%S’) FROM DUAL; — 2013-09-27 00:00:00 SELECT STR_TO_DATE(‘2013-09-27 00:00:00’, ‘%Y-%m-%d %H:%i:%S’) FROM DUAL; — 2013-09-27 09:00:00 SELECT DATE_FORMAT(SUBDATE( ‘2013-09-27’ , interval ‘6’ month ), ‘%Y-%m-%d %H:%i:%S’) FROM...
최근 댓글