รบกวนดูโค้อให้หน่อย timestamp ใน oracle ดึงมาแล้วแสดงเฉพาะวันที่

<?
if ($_GET["txtKeyword"] != " ")
{

$objConnect = oci_connect ("xxxxxxxxx","xxxxxxxxxx","111.11.111.111:1521/DB");


$strSQL="SELECT TT.AUCTION_ID,TT.CUST_ID,TT.LOGIN_TIME,PRICE,AB.BID_TIME,TO_CHAR( AB.BID_TIME, 'YYYY-MM-DD HH24:MI:SS' ) as BT,AB.BID_STATUS FROM AUC_BID AB,(SELECT DISTINCT AUCTION_ID,CUST_ID,LOGIN_TIME, (SELECT MIN(AUC_BID.BID_PRICE) FROM AUC_BID WHERE (AUC_BID.BIDDER=AUC_ONLINE_USER.BIDDER_ID)AND(AUC_BID.AUCTION_ID=AUC_ONLINE_USER.AUCTION_ID)) AS PRICE FROM AUC_ONLINE_USER WHERE AUC_ONLINE_USER.AUCTION_ID = '".$search."' ORDER BY PRICE) TT WHERE (AB.BID_PRICE=TT.PRICE) AND (AB.AUCTION_ID = '".$search."')";




$objParse = oci_parse ($objConnect, $strSQL);
oci_execute ($objParse);
echo " ".$search." ";



?>
<center>

<TABLE width="900" border="1" >
<TR>
<TH width="100">AUCTION_ID</TH>
<TH width="100"> TIN</TH>
<TH width="100"> SEQ_NO</TH>
<TH width="550"> STATUS_LOGIN</TH>
<TH width="50"> STATUS_BID</TH>
<TH width="50"> PRICE</TH>
<TH width="50"> DATE_TIME</TH>
</TR>
<Form method="post" action="Insert_Aun.php" name="frmSearch">
<?
$i = 0;
while ($objResult = oci_fetch_array($objParse,OCI_BOTH))
{
?>
<TR>
<TD width="100"><div align="center"><Input type="text" name="AUCTION_ID<?=$i?>" Size="20" value=<?=$objResult ["AUCTION_ID"] ; ?> ></div></TD>
<TD width="100"><div align="center"><Input type="text" name="CUST_ID<?=$i?>" Size="20" value=<?=$objResult ["CUST_ID"] ; ?> ></div></TD>
<TD width="100"><div align="center"><Input type="text" name="AUCTION_ID<?=$i?>" Size="20" value=<?=$objResult ["AUCTION_ID"] ; ?> ></div></TD>
<TD width="550"><div align="center"><Input type="text" name="LOGIN_TIME<?=$i?>" Size="20" value=<?=$objResult ["LOGIN_TIME"] ; ?> ></div></TD>
<TD width="100"><div align="center"><Input type="text" name="BID_STATUS<?=$i?>" Size="20" value=<?=$objResult ["BID_STATUS"] ; ?> ></div></TD>
<TD width="100"><div align="center"><Input type="text" name="PRICE<?=$i?>" Size="20" value=<?=$objResult ["PRICE"] ; ?> ></div></TD>
<TD width="100"><div align="center"><Input type="text" name="BID_TIME<?=$i?>" Size="20" value=<?=$objResult ["BID_TIME"] ; ?> ></div></TD>

</TR>
<?
$i++;
}
?>
</TABLE>
<INPUT TYPE="hidden" NAME="rowcount" value="<?=$i?>">
<CENTER><INPUT TYPE='submit' value=ตกลง></CENTER>
</FORM>
<?
$today_date = date ("d-M-Y");
$today_time = date ("h:i:s: a");
echo "<B>Today</B> $today_date $today_time";
"<BR>";
echo "จำนวน".$i." ราย ";
//echo " ".$strSQL." ";

?>
  <?
oci_close ($objConnect);
}
?>