求每一天的SQLselect to_date('2012-12','yyyy-mm')+rownum-1 s_d from dual connect by rownum<=last_day(to_date('2012-12','yyyy-mm'))-to_date('2012-12','yyyy-mm')+1
select trunc(to_date('2012-2'), 'mm') + rownum - 1 from dual connect by rownum <= to_char(last_day(to_date('2012-2', 'yyyy-mm')), 'dd')
楼上有一点点问题,修改下select trunc(to_date('2012-12','yyyy-mm'), 'mm') + rownum - 1 from dual connect by rownum <= to_char(last_day(to_date('2012-12', 'yyyy-mm')), 'dd')
select to_date('2012-12'||'-01','yyyy-mm-dd') + rownum - 1 c from dual connect by rownum <= to_char(add_months(to_date('2012-12', 'yyyy-mm'),1)-1, 'dd')类似方法 百度一大堆 一般查询方式有很多种.基本语法要多学习 多变通
select to_date('2012-12'||'-01','yyyy-mm-dd') + rownum - 1 c from dual connect by rownum <= to_char(add_months(to_date('2012-12', 'yyyy-mm'),1)-1, 'dd')
from dual
connect by rownum<=last_day(to_date('2012-12','yyyy-mm'))-to_date('2012-12','yyyy-mm')+1
from dual
connect by rownum <= to_char(last_day(to_date('2012-2', 'yyyy-mm')), 'dd')
from dual
connect by rownum <= to_char(last_day(to_date('2012-12', 'yyyy-mm')), 'dd')
from dual
connect by rownum <= to_char(add_months(to_date('2012-12', 'yyyy-mm'),1)-1, 'dd')类似方法 百度一大堆 一般查询方式有很多种.基本语法要多学习 多变通
select to_date('2012-12'||'-01','yyyy-mm-dd') + rownum - 1 c
from dual
connect by rownum <= to_char(add_months(to_date('2012-12', 'yyyy-mm'),1)-1, 'dd')