oracle根据日期范围查询数据

oracle根据日期范围查询数据

1. $A ="select to_char(ENDTIME,'YYYY-MM-DD HH24:MI:SS ') as ENDTIME ,LOU,FJ,JG,ZHI from $tab where ENDTIME>=  
   
2. to_date('$riqi_start','yyyy-mm-dd HH24:MI:SS') and  ENDTIME<=to_date('$riqi_end','yyyy-mm-dd HH24:MI:SS') AND  LOU='$lou' and FJ='$cs[1]' and LU='A' and rownum<=1000  ORDER BY ID desc";
   
3.   $rsA= oci_parse($conn,$A);
   
4.   oci_execute($rsA);
   
5.   $row1 = oci_fetch_all($rsA,$res,null, null, OCI_FETCHSTATEMENT_BY_ROW +OCI_ASSOC);

复制代码

1. select * from tablename where time>=  
   
2. to_date('2011-05-02','yyyy-mm-dd')   
   
3. and  time<=to_date('2011-05-30','yyyy-mm-dd')

复制代码