ORACLE任意时间段内所有天数查询,没必要借助什么all_objects 无 /* 查询-11-25至-12-28内所有日期天数 */select date '-11-25' + (rownum - 1) dt from dual connect by rownum = (date '-12-28' - date '-11-25' + 1) /* 查询-11-25
ORACLE任意时间段内所有天数查询,没必要借助什么all_objects
/* 查询-11-25至-12-28内所有日期天数 */
select
date '-11-25' + (rownum - 1) dt
from dual connect by rownum <= (date '-12-28' - date '-11-25' + 1)
/* 查询-11-25至-12-28包含的月份,以及每月包含的天数 */
select
to_char(dt,'yyyy-mm'),
count(to_char(dt,'yyyy-mm')) days,
mm
from(
select
date'-11-25' + (rownum - 1) dt,
to_char(last_day(date'-11-25' + (rownum - 1)),'mm') mm
from dual connect by rownum <= (date'-12-28' - date'-11-25' + 1)
)
group by to_char(dt,'yyyy-mm'),mm
order by to_char(dt,'yyyy-mm')
发布php中文网,转载请注明出处,感谢您的尊重!