oracle--获取当前时间前31天的所有日期

提取当前时间前31天的所有日期

	select to_char(sysdate-31 + rownum, 'YYYYMMDD') dates
	from dual 
	connect by rownum<=31
	order by dates desc；

提取当前时间24小时内所有时间

	select dates,times
	from(
		select 
		to_char(sysdate-1+rownum/24,'yyyymmdd') dates,
		to_char(sysdate-1+rownum/24,'hh24')||':00' times
		from dual
		connect by rownum<25)
	order by	dates desc,	times desc;