ACCESS的日期类型要怎么取出来啊。
我在数据库里面的日期是2007-09-11,但是用读出来后就不对了
1189440000就是这个了,我郁闷!
SQL语句
$sql = "select id, typeid, title, adddate from ( select top ";
$sql .= $pager_Size;
$sql .= " * from ( select top ";
$sql .= $pager_Size*($pager_PageID);
$sql .= " * from news where typeid=".$typeid;
$sql .= " ORDER BY id DESC) ORDER BY id ASC )ORDER BY id DESC";这个是分页显示的。
我在数据库里面的日期是2007-09-11,但是用读出来后就不对了
1189440000就是这个了,我郁闷!
SQL语句
$sql = "select id, typeid, title, adddate from ( select top ";
$sql .= $pager_Size;
$sql .= " * from ( select top ";
$sql .= $pager_Size*($pager_PageID);
$sql .= " * from news where typeid=".$typeid;
$sql .= " ORDER BY id DESC) ORDER BY id ASC )ORDER BY id DESC";这个是分页显示的。
===========================================================
http://pcfun.cn/freehost.asp ==> 100M免费ASP+Access php+MySQL空间
其实象这样保存为unix时间戳要方便的多