mysql时间随笔

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()