ADD_DAYS SQL Function

Previous Next

You can use ADD_DAYS to add a specified number of days to a date, as in the following example:

UPDATE   tab1

SET      next_year = ADD_DAYS( SYSDATE, 365 )