日期格式化为字符串: select DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s') as CREATE_TIME from 表名; 字符串转日期时间: insert into 表名(createTime) values(str_to_date('2014-08-20 00:00:00', '%Y-%m-%d %H:%i:%s'));