| 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