SELECT FROM_UNIXTIME('时间戳的字段名称', '%Y-%m-%d %H:%i:%s') FROM `表名`
http://www.cnblogs.com/tdalcn/archive/2011/04/23/2025465.html