按天、周、月、自定义时间段统计

if("day".equals(tongjiType)){
sql =
"select task.task_name,to_char(sysdate, 'yyyy-mm-dd'),n" +
"
count(log.timertaskid),n" +
"
sum(log.successcount),n" +
"
sum(log.failcount)n" +
"
from table_exchange_task taskn" +
"
join table_exchange_timer_task timern" +
"
join table_exchange_timer_task_log logn" +
"
on (timer.id = log.timertaskid) ON(task.id = timer.task_id)n" +
" where to_char(sysdate, 'yyyy-mm-dd') =n" +
"
to_char(log.starttime, 'yyyy-mm-dd')n" +
" group by task.task_name";
} else if("week".equals(tongjiType)) {
sql =
"select task.task_name,1,n" +
"
count(log.timertaskid),n" +
"
sum(log.successcount),n" +
"
sum(log.failcount)n" +
"
from table_exchange_task taskn" +
"
join table_exchange_timer_task timern" +
"
join table_exchange_timer_task_log logn" +
"
on (timer.id = log.timertaskid) ON(task.id = timer.task_id)n" +
"
where to_char(log.starttime, 'ww') = (select to_char(sysdate, 'ww') from dual)n" +
"
group by task.task_name";
} else if("month".equals(tongjiType)) {
sql =
"select task.task_name,n" +
"
to_char(sysdate, 'yyyy-mm'),n" +
"
count(log.timertaskid),n" +
"
sum(log.successcount),n" +
"
sum(log.failcount)n" +
" from table_exchange_task taskn" +
" join table_exchange_timer_task timern" +
" join table_exchange_timer_task_log logn" +
"
on (timer.id = log.timertaskid) ON(task.id = timer.task_id)n" +
"where to_char(sysdate, 'yyyy-mm') =n" +
"
to_char(log.starttime, 'yyyy-mm')n" +
"group by task.task_name";
} else if ("diy".equals(tongjiType)) {
String startTime = taskLog.getStartTime().toString() ;
String endTime = taskLog.getEndTime().toString() ;
sql =
"select task.task_name,111,n" +
"
count(log.timertaskid),n" +
"
sum(log.successcount),n" +
"
sum(log.failcount)n" +
" from table_exchange_task taskn" +
" join table_exchange_timer_task timern" +
" join table_exchange_timer_task_log logn" +
"
on (timer.id = log.timertaskid) ON(task.id = timer.task_id)n" +
"where log.starttime>to_date('" + startTime.substring(0, startTime.length()-2) + "','yyyy-mm-dd hh24:mi:ss')n" +
" and log.endtime<to_date('" + endTime.substring(0, endTime.length()-2) + "','yyyy-mm-dd hh24:mi:ss')n" +
"group by task.task_name";
}

最后

以上就是温柔大炮最近收集整理的关于按天、周、月、自定义时间段统计的全部内容，更多相关按天、周、月、自定义时间段统计内容请搜索靠谱客的其他文章。