SQL query to find the last day of the previous month.

• Use the DATEADD function to subtract one day from the first day of the current month

• Use the DAY function to get the day of the month

• Subtract the da...read more

select last_day(add_months(sysdate,-1)) as Last_day

from dual;