dateadd adds a positive or negative quantity of units to a date (in the internal date time format), and returns a new date so formed. The unit is specified as a string and can be one of the following: 'second', 'minute', 'hour', 'day', 'month', or 'year'. Use datestring to convert the result to a human-readable string.
Add 10 days to 1996.10.10.
SQL> select dateadd ('day', 10, stringdate ('1996.10.10')); callret BINARY _______________________________________________________________________________ 1996-10-20 01:00:00 1 Rows. -- 92 msec.