date Column type
페이지 정보
작성자 최고관리자 작성일 21-02-10 17:15 조회 6,068 댓글 0본문
*Column type* *"Zero" value*
`DATETIME' `'0000-00-00 00:00:00''
`DATE' `'0000-00-00''
`TIMESTAMP' `00000000000000' (length depends on display size)
`TIME' `'00:00:00''
`YEAR' `0000'
select DATE_FORMAT(date_col, '%Y-%m-%d') as dcol from table_name
`DATETIME' `'0000-00-00 00:00:00''
`DATE' `'0000-00-00''
`TIMESTAMP' `00000000000000' (length depends on display size)
`TIME' `'00:00:00''
`YEAR' `0000'
select DATE_FORMAT(date_col, '%Y-%m-%d') as dcol from table_name
댓글목록 0
등록된 댓글이 없습니다.