SELECT TO_CHAR(NOW(), 'YYYY-MM-DD HH24:MI:SS') THISDATETIME,
TO_CHAR(NOW(), 'YYYY-MM') THISMONTH, TO_CHAR(NOW() + INTERVAL '1 MONTH','YYYY-MM') NEXTMONTH
TO_CHAR(NOW(), 'YYYY-MM') THISMONTH, TO_CHAR(NOW() + INTERVAL '1 MONTH','YYYY-MM') NEXTMONTH