![DATE function [Date and time]](arrow-left.gif){kind=icon}
![DATEDIFF function [Date and time]](arrow-right.gif){kind=icon}
Returns the date produced by adding the specified number of the specified date parts to a date.
DATEADD ( date-part, numeric-expression, date-expression )
date-part The date-part to be added to the date.
For a complete listing of allowed date-parts, see the section “Date parts”.
numeric-expression The number of date-parts to be added to the date. The numeric_expression can be any numeric type; the value is truncated to an integer.
date-expression The date to be modified.
The following statement returns the value 1995-11-02 00:00:00.000.
SELECT DATEADD( month, 102, '1987/05/02' ) FROM iq_dummy
DATEADD is a Transact-SQL compatible data manipulation function.
