最近在做gp数据查询的任务,有一段Oracle中函数在gp语法该怎么表达,求大神指教
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2016-07', 'yyyy-mm'), ROWNUM - 1),
'YYYY-mm') AS yearMonths
FROM DUAL
CONNECT BY ROWNUM <=
(SELECT MONTHS_BETWEEN(ADD_MONTHS(TO_DATE('2016-11', 'yyyy-mm'), 1),
TO_DATE('2016-07', 'yyyy-mm'))
FROM DUAL)
这一段sql用gp数据库语法该怎么写