1. | ADD_MONTHS: Schedule a number of months after the current date | | |
2. | Adding one month to SYSDATE | | |
3. | Adding two months to current date | | |
4. | Combine to_char with add_months | | |
5. | select add_months( sysdate, 12 ) "Next Year" | | |
6. | select add_months( sysdate, -12 ) "Last Ye |
No comments:
Post a Comment