+ (Add) (TSQL Operator)

Adds two numbers. It also adds a number of days to a datetime, or a time to a date.

Syntax

expression + expression

datetime + number_of_days

date + time

Arguments

expression
is a numeric expression of type tinyint, smallint, int, bigint, money, numeric, float.
datetime
is an expression of type datetime.
number_of_days
is the number of days to add to datetime. It is of type int.
date
is an expression of type date.
time
is an expression of type time, to add to date.

Return Types

For arithmetic addition, returns the datatype of the expression with the highest type precedence.

For datetime + number_of_days and date + time, returns datetime.

Remarks

MS SQL Server doesn’t allow date + time.

Examples

PRINT 123.45 + 1000;

-- varchar is converted to int, because int has highest type precedence
PRINT '123' + 50;

The result is:

1123.45
173

Example datetime + number_of_days

DECLARE @d DATETIME = '1978-02-01 13:30';
PRINT @d + 5;

The result is:

1978-02-06 13:30:00

Example date + time

DECLARE @d DATE = '1978-02-01 13:30';
DECLARE @t TIME = '13:30';

PRINT @d + @t;

The result is:

1978-02-01 13:30:00
RSQL, a simple alternative to Microsoft SQL Server