iteye_1571的博客

<insert id="batchInsertB2B" parameterType="ArrayList"> insert into xxxxtable(hkgs,hkgsjsda,office,asdf,ddd,ffff,supfullName,classtype,agent_type,remark) <foreach collection="list" item="...

字段类型为date 今日 select * from 表名 where to_char(字段名,'dd')=to_char(sysdate,'dd') 昨日 select * from  表名 where to_char(字段名,'dd')= to_char(sysdate-1,'dd')本周  select * from 表名 where to_char(字段名,'iw')=to_c...