关于全日期的统计

最新推荐文章于 2025-04-21 14:42:48 发布

原创最新推荐文章于 2025-04-21 14:42:48 发布 · 552 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#date #null

数据库专栏收录该内容

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(+) ";