ใช้ jquery datatable กับ oralce 9i ติด คำสั่ง ค้นหา กับ sort วันที่

<?php
//fetch.php


$columns = array('HEADER_ID', 'SCAN_NO', 'DATESCAN','EMP_ID','EMP_TH_LNAME', 'SUB_SECT_CODE','GRP_CODE','DETAIL','DELECT');

$query = 'SELECT * from SFCSYS.SFC_LS_WSD_HEADER INNER join HRSYS.PERSONNEL_MASTER_TEMP
ON  SFCSYS.SFC_LS_WSD_HEADER.EMP_ID = HRSYS.PERSONNEL_MASTER_TEMP.EMP_ID where
      ';
/*/ EROR ตรงนี้ 
if($_POST["is_date_search"] == "yes")
{

 $query .= 'TO_CHAR(SCAN_DATE, DD/MM/YYYY)  BETWEEN'.$_POST['start_date'].' AND '$_POST['end_date']' AND';
}
EROR ตรงนี้ 
if(isset($_POST["search"]["value"]))
{
  $query .= "
  (GROUP_CODE LIKE %'".$_POST["search"]["value"]."'%)
 ";
}
/*/
if(isset($_POST["order"]))
{
 $query2 .= 'ORDER BY  '.$columns[$_POST['order']['0']['column']].' '.$_POST['order']['0']['dir'].'
 ';
}
else
{
 $query2 .= 'ORDER BY SCAN_DATE DESC ';
}

$query1 = '';

if($_POST["length"] != -1)
{

 $query1 = 'ROWNUM BETWEEN  ' . $_POST['start'].'AND ' . $_POST['length'];
}


$objParse = oci_parse($objConnect, $query.$query1.$query2);
oci_execute ($objParse,OCI_DEFAULT);

$number_filter_row =  oci_fetch_all($objParse, $show2, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);  //  คำสั่ง นี้ oci_fetch_all ใช้ในการ แสดงผลข้อมูลและใช้ในการนับจำนวน ข้อมูลที่ Query ออกมา
$data = array();
for ($iw = 0; $iw < $number_filter_row ; $iw++) {
 $sub_array = array();
 $sub_array[] = '<center><font  size="3">'.$show2 [$iw]['HEADER_ID'];
$sub_array[] = '<center><font  size="3">'.$show2 [$iw]['SCAN_NO'];
$sub_array[] = '<center><font  size="3">'.$show2 [$iw]['SCAN_DATE'];
$sub_array[] = '<center><font  size="3">'.$show2 [$iw]['EMP_ID'];
$NameEMPLOYEE=$show2 [$iw]['EMP_TH_NAME']." ".$show2 [$iw]['EMP_TH_LNAME'];
$sub_array[] = '<center><font  size="3">'.$NameEMPLOYEE;
$sub_array[] = '<center><font  size="3">'.$show2 [$iw]['SUB_SECT_CODE'];
$sub_array[] = '<center><font  size="3">'.$show2 [$iw]['GRP_CODE'];
$sub_array[] = '<center><font  size="3"><a href="detailscan.php?idscan='.$show2 [$iw]['HEADER_ID'].'"><center><button type="button" class="btn btn-warning bt-xs t">
รายละเอียด</button> </a>';
$sub_array[] = '<center><font  size="3"><button type="button" name="delete" class="btn btn-warning bt-xs delete" id="'.$show2 [$iw]['HEADER_ID']
.'"nameE="'.$show2 [$iw]['EMP_TH_NAME']." ".$show2 [$iw]['EMP_TH_LNAME'].'">
ลบ</button></a>';
 $data[] = $sub_array;
}

function get_all_data($objConnect)
{
 $query = "SELECT * from SFCSYS.SFC_LS_WSD_HEADER INNER join HRSYS.PERSONNEL_MASTER_TEMP
ON  SFCSYS.SFC_LS_WSD_HEADER.EMP_ID = HRSYS.PERSONNEL_MASTER_TEMP.EMP_ID";
   $objParse = oci_parse($objConnect, $query);
   oci_execute ($objParse,OCI_DEFAULT);
 return oci_fetch_all($objParse, $show2, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
}

$output = array(
 "draw"    => intval($_POST["draw"]),
 "recordsTotal"  =>  get_all_data($objConnect),
 "recordsFiltered" => $number_filter_row,
 "data"    => $data
);

echo json_encode($output);


?>