w
1 SELECT ro.*, FROM_UNIXTIME(ro.wstart,‘%Y%m%d‘) FROM room_order ro
FROM_UNIXTIME(unix_timestamp), FROM_UNIXTIME(unix_timestamp,format)
原文：http://www.cnblogs.com/yuanjiangw/p/6418137.html
