select FROM_UNIXTIME(1291345910,'%Y-%m-%d %h:%i:%s'); 转载于:https://www.cnblogs.com/kuailewangzi1212/archive/2012/06/14/2549976.html