例如将:1532311689 =》2018-07-23 10:8:9
语句如下:select *,FROM_UNIXTIME(time,’%Y-%m-%d %H:%i:%s’) as date from red_packet
重点是:FROM_UNIXTIME(addtime,’%Y-%m-%d %H:%i:%s’)
例如将:1532311689 =》2018-07-23 10:8:9
语句如下:select *,FROM_UNIXTIME(time,’%Y-%m-%d %H:%i:%s’) as date from red_packet
重点是:FROM_UNIXTIME(addtime,’%Y-%m-%d %H:%i:%s’)