Arithmetic operators

Operator

Meaning

datetime

smalldatetime

Analytics Platform System (PDW)

Arithmetic operators run mathematical operations on two expressions of one or more data types. They’re run from the numeric data type category. For more information about data type categories, see.

• (Add)

Addition

(Subtract)

Subtraction

• (Multiply)

Multiplication

/ (Divide)

Division

%

(Modulo)

Returns the integer remainder of a division. For example,

because the remainder of divided by is.

The plus (

) and minus (

) operators can also be used to run arithmetic operations on and values.

For more information about the precision and scale of an arithmetic operation result, see

Precision, scale, and length.

Mathematical functions (Transact-SQL)

Data types (Transact-SQL)

Expressions (Transact-SQL)

12 % 5 = 2

12

5

2

+

-