查日期區間,但資料庫是datetime的欄位

[yehlu]

代碼: 選擇全部

<script language="JavaScript" type="text/javascript">
function add_time(temp,temp1){
    if(temp.value.length==10 ){
	    if(temp1==0){
            temp.value = temp.value + " 00:00:00";
		}else{
            temp.value = temp.value + " 23:59:59";
		}
    }
}
function cut_time(temp){
    if(temp.value.length>10 ){
        temp.value = temp.value.substring(0,10);
    }
}
</script>

起始日期

代碼: 選擇全部

<input id="stock_orderSearchs_order_date" value="" maxlength="20" size="10" name="s_order_date" onBlur="add_time(this,0)" onFocus="cut_time(this)">

結束日期

代碼: 選擇全部

<input id="stock_orderSearchs_order_date1" value="" maxlength="20" size="10" name="s_order_date1" onBlur="add_time(this,1)" onFocus="cut_time(this)">