http://blog.163.com/dreamman_yx/blog/static/26526894201053115538643/
数据库日期类型是int类型的,该查询结果是datetime类型的
SELECT from_unixtime( dateline )
FROM cdb_posts
如果原来类型是datetime类型,查询结果要是int类型则
SELECT unix_timestamp( dateline )
FROM cdb_posts
php时间转换,关键是看你在什么时候要获得对应的时间类型
$timestamp = 1210003200;
$datetime = date('Y-m-d H:i:s', $timestamp);
echo "该时间戳代表的时间:", $datetime, "
\n";
echo "从此时间重新转回时间戳:", strtotime($datetime), "
\n";
测试代码:
SELECT FROM_UNIXTIME( '1245464456' ) mytime
FROM ecs_order_goods
显示数据