sql中取得传入月份值的所有天数 使用oracle pl/sql 无 select lpad(rownum, 2, 0) ymd from dualconnect by rownum = (select add_months(trunc(to_date('201002', 'yyyymm'), 'mm'), 1) - trunc(to_date('201002', 'yyyymm'), 'mm') from dual)
sql中取得传入月份值的所有天数
使用oracle
pl/sql
select lpad(rownum, 2, 0) ymd from dualconnect by rownum <= (select add_months(trunc(to_date('201002', 'yyyymm'), 'mm'), 1) - trunc(to_date('201002', 'yyyymm'), 'mm') from dual)