日期:2014-05-16  浏览次数:20488 次

Oracle中 取中间时间段

S.ENTRANCEDATE between '20110701' and '20110707'

也可以这样写

<isNotEmpty property="ENTRANCEDATESTART">
AND S.ENTRANCEDATE >#ENTRANCEDATESTART#
</isNotEmpty>
<isNotEmpty property="ENTRANCEDATEEND">
AND S.ENTRANCEDATE <![CDATA[<]]> #ENTRANCEDATEEND#
</isNotEmpty>