oracle根据日期范围查询数据
oracle根据日期范围查询数据$A ="select to_char(ENDTIME,'YYYY-MM-DD HH24:MI:SS ') as ENDTIME ,LOU,FJ,JG,ZHI from $tab where ENDTIME>=
to_date('$riqi_start','yyyy-mm-dd HH24:MI:SS') andENDTIME<=to_date('$riqi_end','yyyy-mm-dd HH24:MI:SS') ANDLOU='$lou' and FJ='$cs' and LU='A' and rownum<=1000ORDER BY ID desc";
$rsA= oci_parse($conn,$A);
oci_execute($rsA);
$row1 = oci_fetch_all($rsA,$res,null, null, OCI_FETCHSTATEMENT_BY_ROW +OCI_ASSOC);
select * from tablename where time>=
to_date('2011-05-02','yyyy-mm-dd')
andtime<=to_date('2011-05-30','yyyy-mm-dd')
页:
[1]