oracle得到两年的日期
摘要:
SELECT ROWNUM,'1' AS FLAG ,(TO_DATE(TO_CHAR(DATE'2015-12-31','YYYY')||'-01-01','YYYY-MM-DD')+ ROWNUM - 1) AS DATE_DT ,DATE'2015-12-31' AS DATA_DATE ,S 阅读全文
posted @ 2016-04-26 17:02 vbvb520 阅读(335) 评论(0) 推荐(0)
posted @ 2016-04-26 17:02 vbvb520 阅读(335) 评论(0) 推荐(0)