oralce to_date|ORALCE 查询当前月的所有日期sql语句

【www.bbyears.com--Oracle教程】

1. 查询将来 6 个月的月份：

	  
		 代码如下
		
	  
	  
		
SELECT to_char(add_months(SYSDATE, ROWNUM), "yyyy-mm")
  FROM dual
CONNECT BY ROWNUM <= 6

	  
	

2. 查询当前月的所有日期

	  
		 代码如下
		
	  
	  
		
SELECT TRUNC(SYSDATE, "MM") + ROWNUM - 1
  FROM DUAL
CONNECT BY ROWNUM <= TO_NUMBER(TO_CHAR(LAST_DAY(SYSDATE), "dd"))

	  
	

<script type="text/javascript"> if ($ != jQuery) { $ = jQuery.noConflict(); } var isLogined = false; var cb_blogId = 57326; var cb_entryId = 2303812; var cb_blogApp = "hemingwang0902"; var cb_blogUserGuid = "1ae66eca-fa54-de11-9510-001cf0cd104b"; var cb_entryCreatedDate = "2011/12/27 17:30:00"; </script>

本文来源：http://www.bbyears.com/shujuku/33143.html