Query migration Oracle to Mssql
SELECT to_char(TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE,
0),'YYYYMM'),'YYYYMM'),'DD-MON-YYYY'),
to_char(TO_DATE(TO_CHAR(ADD_MONTHS(SYSDATE, + 1),'YYYYMM'),'YYYYMM') -
1,'DD-MON-YYYY') from dual
can any one help to convert this oracle query into ms sql query ??? plz!!!!!
No comments:
Post a Comment