oracle 取当前日期时间的前一天前一小时前一分钟前一秒
[url]http://wentao365.iteye.com/blog/779492[/url]
[img]http://dl.iteye.com/upload/attachment/599060/51703236-416a-308b-81a3-e7b0ffbbd976.jpg[/img]
[url]http://wentao365.iteye.com/blog/779492[/url]
<select id="query" parameterClass="DownloadObj" resultMap="downloadMap">
select <include refid="downloadField" /> from YESKY_APP_DOWNLOAD where CREATE_TIME > sysdate-(3/24/60/60) and ip = #ip#
</select>
[img]http://dl.iteye.com/upload/attachment/599060/51703236-416a-308b-81a3-e7b0ffbbd976.jpg[/img]