SELECT id, title,createdate,FROM_UNIXTIME(UNIX_TIMESTAMP(createdate),'%Y-%m-%d') AS createdate--该片段来自于http://www.codesnippet.cn/detail/210120148605.html
来源: http://www.codesnippet.cn/detail/210120148605.html