time.substring(3,5);
var endtime=$("#date02").val();
endtime=endtime.substring(0,2)+endtime.substring(3,5);
$("#starttime_add").val(starttime);
$("#endtime_add").val(endtime);
sql查询显示(oracle)
substr(t.starttime,1,2)||':'||substr(t.starttime,3,2) as starttime,
substr(t.endtime,1,2)||':'||substr(t.endtime,3,2) as endtime,