Why does the top one work yet the bottom one doesen't?
SELECT LAST_DAY(TO_DATE(Add_months(SYSDATE, -1))) FROM dual
SELECT NEXT_DAY(TO_DATE(Add_months(SYSDATE, -3))) FROM dual
basically i want to be able to find the first date of a given month given the current date.