关于全日期的统计

dawnstar_hoo

于 2009-08-05 13:35:00 发布

阅读量552

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： date null

本文链接：https://blog.youkuaiyun.com/dawnstar_hoo/article/details/4411628

数据库专栏收录该内容

2 篇文章

订阅专栏

            "select t1.s_date as mydate, decode(t2.iDate, null, 0, t2.iCount) as icount " +
            " from " +
            "(select to_date('{0}','yyyy-mm-dd')+(rownum-1) s_date from all_tables " +
            "where rownum <= " +
            "(select to_date('{1}','yyyy-mm-dd') - to_date('{0}','yyyy-mm-dd')+1 from dual))t1, " +
            "(select to_date(to_char(ffailtime,'YYYY-MM-DD'), 'YYYY-MM-DD') as iDate, count(*) as iCount from tabservfail " +
            "where ffailtime between to_date('{0}', 'YYYY-MM-DD') and to_date('{1}', 'YYYY-MM-DD') " +
            "group by to_char(ffailtime,'YYYY-MM-DD'))t2 " +
            "where t1.s_date = t2.iDate(+) ";