DATEADD function [Date and time]

Returns a TIMESTAMP or TIMESTAMP WITH TIME ZONE value produced by adding a date part to its argument.

DATEADD( date-part, integer-expression, timestamp-expression )

date-part :
year 
| quarter 
| month 
| week 
| day 
| dayofyear 
| hour 
| minute 
| second 
| millisecond
| microsecond

date-part The date part that integer-expression represents.
For a complete listing of allowed date parts, see Specifying date parts.
integer-expression The number of date-part values to be added to timestamp-expression. Note that integer-expression can be any numeric type, but its value is truncated to an INTEGER.
timestamp-expression The TIMESTAMP or TIMESTAMP WITH TIME ZONE value to be modified.

The following statement returns the TIMESTAMP value 1995-11-02 00:00:00.000.

SELECT DATEADD( month, 102, '1987/05/02' );

The following statement returns the TIMESTAMP value 1987-05-02 04:00:00.000.

SELECT DATEADD( hour, 4, '1987/05/02' );

The following statement returns the TIMESTAMP WITH TIME ZONE value 1987-05-06 11:33:00.000+04:00

SELECT DATEADD( day, 4, CAST( '1987/05/02 11:33:00.000000+04:00' as TIMESTAMP WITH TIME ZONE ));

Discuss this page in DocCommentXchange.