select id, TO_DAYS(NOW()) - TO_DAYS(createTime) as dayFactor, datediff(NOW(),createTime) as dayFactor1from code_snippetlimit 10--该片段来自于http://www.codesnippet.cn/detail/290920136252.html
来源: http://www.codesnippet.cn/detail/290920136252.html