日期处理

最新推荐文章于 2023-09-20 17:13:42 发布

tczxg

最新推荐文章于 2023-09-20 17:13:42 发布

阅读量311

点赞数

分类专栏： oracle 文章标签： date

本文链接：https://blog.csdn.net/tczxg/article/details/5192916

版权

oracle 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

1. 本月或者本季度统计

<isNotEmpty prepend=" and " property="map.this_month">to_char(sysdate, 'yyyyMM') = to_char(help_time, 'yyyyMM')</isNotEmpty>
 <isNotEmpty prepend=" and " property="map.this_season">
 <![CDATA[to_char(to_char(sysdate,'q')*3-2) <= to_char(help_time, 'MM') and to_char(help_time, 'MM') <= to_char(to_char(sysdate,'q')*3 )]]>
 </isNotEmpty>

2.几个月前的统计

<isNotEmpty prepend=" and " property="map.within_three_month">
 <![CDATA[to_char(add_date,'yyyy-mm-dd') >= to_char(add_months(sysdate,-3),'yyyy-mm-dd')]]>
 </isNotEmpty>
 <isNotEmpty prepend=" and " property="map.before_three_month">
 <![CDATA[to_char(add_date,'yyyy-mm-dd') <= to_char(add_months(sysdate,-3),'yyyy-mm-dd')]]>
 </isNotEmpty>