帝国系统SQL语句如何调用时间
<?php
$ecms_bq_sql2 = sys_ReturnEcmsLoopBq("select * from {$dbtbpre}ecms_news where classid = '$bqr[classid]' order by newstime desc limit 6", 20, 24, 0);
$bqno2 = 0;
while ($bqr2 = $empire->fetch($ecms_bq_sql2)) {
$bqsr2 = sys_ReturnEcmsLoopStext($bqr2);
$bqno2++;
?>
<li><a href="<?= 'http://' . $_SERVER['HTTP_HOST']; ?>/e/action/ShowInfo.php?classid=<?= $bqr['classid'] ?>&id=<?= $bqr2['id'] ?>">
<i>○</i>
<?= esub($bqr2[title], 35, '…') ?>
</a>
<span>
<?=date('Y-m-d',$bqr[newstime])?> //这里的时间:显示是1970的,要怎么改呀
</span>
</li>
<?php
}
?>
$ecms_bq_sql2 = sys_ReturnEcmsLoopBq("select * from {$dbtbpre}ecms_news where classid = '$bqr[classid]' order by newstime desc limit 6", 20, 24, 0);
$bqno2 = 0;
while ($bqr2 = $empire->fetch($ecms_bq_sql2)) {
$bqsr2 = sys_ReturnEcmsLoopStext($bqr2);
$bqno2++;
?>
<li><a href="<?= 'http://' . $_SERVER['HTTP_HOST']; ?>/e/action/ShowInfo.php?classid=<?= $bqr['classid'] ?>&id=<?= $bqr2['id'] ?>">
<i>○</i>
<?= esub($bqr2[title], 35, '…') ?>
</a>
<span>
<?=date('Y-m-d',$bqr[newstime])?> //这里的时间:显示是1970的,要怎么改呀
</span>
</li>
<?php
}
?>