Oracle中 取中间时间段
S.ENTRANCEDATE between '20110701' and '20110707'
也可以这样写
<isNotEmpty property="ENTRANCEDATESTART">
AND S.ENTRANCEDATE >#ENTRANCEDATESTART#
</isNotEmpty>
<isNotEmpty property="ENTRANCEDATEEND">
AND S.ENTRANCEDATE <![CDATA[<]]> #ENTRANCEDATEEND#
</isNotEmpty>
