Name
dateadd — arithmetic add to a date
Synopsis
dateadd
(
|
in unit string , |
| in number integer , | |
in
date
datetime
); |
Description
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.
Parameters
unit
String value denoting the unit to use in the addition.
number
Integer number of
unit
units to be added.
date
Datetime value to which the
number
of
unit
s is to be added
Examples
Example 24.70. Simple date addition
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.