DATE_FORMAT(FROM_UNIXTIME(chattime),’%Y-%m-%d’)

SELECT DATE_FORMAT(FROM_UNIXTIME(s_time),’%Y-%m-%d’) FROM sdb_scarebuying_scare_buying;

SELECT a.goods_id,b.name,b.price,DATE_FORMAT(FROM_UNIXTIME(a.s_time),’%Y-%m-%d’) AS start_time,DATE_FORMAT(FROM_UNIXTIME(a.e_time),’%Y-%m-%d’) AS end_time,a.scare_count,a.scare_price,a.scare_mprice,a.buycountlimit,a.goodscore

FROM sdb_scarebuying_scare_buying a LEFT JOIN sdb_goods b ON a.goods_id=b.goods_id;