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

SQeeLJun 21 2021

Hello, I'm used to writing T-SQL, I am not very familiar with PL/SQL. I am trying to rewrite ORACLE queries into T-SQL. Could someone tell me what the following code is trying to accomplish?
[Myfield] BETWEEN TRUNC(ADD_MONTHS (sysdate, -1), 'MM') AND TRUNC(sysdate, 'MM') -1)

This post has been answered by Frank Kulash on Jun 21 2021
Jump to Answer
Comments
Post Details
Added on Jun 21 2021
3 comments
3,055 views