SELECT FROM_UNIXTIME(create_time,‘%Y-%m-%d %H:%i:%s‘) FROM `order`; select date_add(FROM_UNIXTIME(create_time,‘%Y-%m-%d %H:%i:%s‘), interval 48 hour) FROM `order`; select NOW()
mysql时间随笔
原文：http://www.cnblogs.com/rainblack/p/5547113.html
