雅安论坛

标题: oracle根据日期范围查询数据 [打印本页]

---

作者: 匿名    时间: 2021-9-30 12:06
标题: 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')

复制代码

---

欢迎光临 雅安论坛 (https://www.yaanbbs.net/)

Powered by Discuz! X3.4