Table of contents
Collapse the table of content
Expand the table of content

- (Subtract) (U-SQL)

Michael Rys|Last Updated: 5/15/2018
4 Contributors

Subtracts two numbers (an arithmetic subtraction operator). Can also calculate date and time differences.

Subtract_Operator :=                                                                                     
     expression '-' expression.

Semantics of Syntax Elements

  • expression
    Is the expression to subtract.

Return Type

Returns the data type of the argument with the higher precedence.


  • The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
  • The scripts can be executed locally. An Azure subscription and Azure Data Lake Analytics account is not needed when executed locally.

Subtract with Numeric Types

@data = 
        ( VALUES
        ) AS T(aNumber);

DECLARE @val int = 5;

@result =
    SELECT 38 - 5 AS Int1,
           aNumber - 5 AS Int2,
           aNumber - @val AS Int3,
           aNumber - (int?)null AS intNull
    FROM @data;

OUTPUT @result
TO "/ReferenceGuide/Operators/Arithmetic/Subtract1.txt"
USING Outputters.Csv();

Subtract with Temporal Types

@data = 
        ( VALUES
        (new DateTime(2016,05,31))
        ) AS T(aDate);

@result =
    SELECT aDate - new System.TimeSpan(1, 0, 0, 0) AS date1,
          (new TimeSpan(1, 0, 0, 0) - new TimeSpan(0, 1, 0, 0)).ToString() AS date2,
          (aDate - new DateTime(2016,05,1)).Days AS date3
    FROM @data;

OUTPUT @result
TO "/ReferenceGuide/Operators/Arithmetic/Subtract2.txt"
USING Outputters.Csv();

See Also

© 2018 Microsoft