Jechue World

[MySQL] Date 날짜 형식 바꾸기

날짜 형식 "yyyy-mm-dd hh:mi:ss"

DATE_FORMAT( 테이블명 or  컬럼명 or 테이블명.컬럼명, '%Y-%m-%d %H:%i:%s' ) AS XXX

예) 쿼리

SELECT 

A.commonID AS commonId,

A.ResourceDomain AS resourceDomain,

A.UseYN AS useYN,

DATE_FORMAT(A.RegDate, '%Y-%m-%d %H:%i:%s' ) AS regDate,

DATE_FORMAT(A.UpdateDate, '%Y-%m-%d %H:%i:%s' ) AS updateDate

FROM top_commoninfo A

WHERE A.CommonID = #{commonId}

예) 자바에서

http://stackoverflow.com/questions/21879382/convert-string-to-mysql-date-format

형식들

http://j07051.tistory.com/606