"add_months" and "interval"
694068Aug 25 2009 — edited Aug 25 2009please tell me what is the difference between the below query.i need to take the last month date using the current date.Which query will be the correct one and whats the difference.
select trunc(sysdate)+ interval '1' month from dual;
select trunc(add_months(sysdate,1)) from dual;