mysql 查询 int类型日期转换成datetime类型
数据库日期类型是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(`order_create_time`) FROM wb_order WHERE MONTH(FROM_UNIXTIME(`order_create_time`))=9