SELECT UNIX_TIMESTAMP(`created_at`) ,FROM_UNIXTIME(UNIX_TIMESTAMP(`created_at`),'%Y-%m-%d'),created_at FROM `sales_flat_quote`
UNIX_TIMESTAMP 把 2018-02-23 20:36:11 格式化为TIMESTAMP
FROM_UNIXTIME 把 TIMESTAMP 格式话为 %Y-%m-%d
SELECT UNIX_TIMESTAMP(`created_at`) ,FROM_UNIXTIME(UNIX_TIMESTAMP(`created_at`),'%Y-%m-%d'),created_at FROM `sales_flat_quote`
UNIX_TIMESTAMP 把 2018-02-23 20:36:11 格式化为TIMESTAMP
FROM_UNIXTIME 把 TIMESTAMP 格式话为 %Y-%m-%d