oracle数据库使用sql语句获取一段连续的日期

原文链接：https://blog.youkuaiyun.com/studententity/article/details/79889499

 

oracle数据库，使用sql语句获取一段连续的日期：

SELECT
	TO_CHAR (
		TO_DATE ('2018-11-08', 'yyyy-mm-dd') + ROWNUM - 1,
		'yyyy-mm-dd'
	) AS sjsj,
	ROWNUM,
	0 datas
FROM
	dual CONNECT BY ROWNUM <= (
		TO_DATE ('2018-11-9', 'yyyy-mm-dd') - TO_DATE ('2018-11-08', 'yyyy-mm-dd') + 1
	);