Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"add_months" and "interval"

694068Aug 25 2009 — edited Aug 25 2009
please 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2009
Added on Aug 25 2009
4 comments
950 views