mysql提供了一个时间戳格式化函数from_unixtime来转换格式
FROM_UNIXTIME(1344887103,
'%Y-%M-%D %h:%i:%s'
);
db('') -> where($where) ->field('FROM_UNIXTIME(time) as time') -> find();
from_unxitime语法说明:
from_unixtime
(unix_timestamp, format)
返回Unix时间标记的一个字符串,根据format格式化。如果format为空默认会使用%Y-%m-%d %H:%i:%s的格式
mysql> select from_unixtime(1459338786);
+---------------------------+
| from_unixtime(1459338786) |
+---------------------------+
| 2016-03-30 19:53:06 |
+---------------------------+
1 row in set (0.00 sec)
mysql> select from_unixtime(1459338786, '%Y-%m-%d %H:%i:%s');
+------------------------------------------------+
| from_unixtime(1459338786, '%Y-%m-%d %H:%i:%s') |
+------------------------------------------------+
| 2016-03-30 19:53:06 |
+------------------------------------------------+
1 row in set (0.00 sec)