อยากทราบวิธีการ search ข้อมูล แบบ DATETIME ซึงผมใช้ ปติทินในการ search แต่จะ search เฉพาะเวลา ล่าสุดขึ้นมาโชวเท่านั้น ครับ php to oracle นะครับ

Select * 
FROM test_table 
WHERE user_id = value 
AND date_added = (select max(date_added) 
   from test_table 
   where user_id = value)

}else if($TERMINAL!="" and $MERCHANT=="")
{ $strSQL="select * from  debuglog.logs WHERE TERMINAL = '".$_GET["TERMINAL"]. " and rownum = '1' order by DATETIME  desc '"; 

}else if($TERMINAL=="" and $MERCHANT!="")
{$strSQL="select * from  debuglog.logs WHERE MERCHANT = '".$_GET["MERCHANT"]."and rownum = '1' order by DATETIME  desc '"; 

}else if($TERMINAL!="" and $MERCHANT!="" ) 
{$strSQL="select * from  debuglog.logs where TERMINAL = '".$_GET["TERMINAL"]. "  and MERCHANT = '".$_GET["MERCHANT"]. " and rownum = '1' order by DATETIME  desc '"; 

}else if($dc!="" and  $dc2!="")
{$strSQL="select *  from debuglog.logs d where to_char(D.DATETIME,'YYYYMMDD') BETWEEN '$_GET[dc]' and '$_GET[dc2] and rownum = '1' order by DATETIME  desc '";