Skip to main content

DB_Column.-

-other

Group: Operators
Aliases: minus, subtract, time difference

Documentation

Element-wise subtraction. Allows to subtract numeric types or compute a difference between two date/time values.

Returns a column containing the result of subtracting other from each element of self. If other is a column, the operation is performed pairwise between corresponding elements of self and other.

Arguments

  • other: The other column to subtract from this column.

Remarks

Arithmetic Overflow

For integer columns, the operation may yield results that will not fit into the range supported by the column. In such case, the in-memory backend will replace such results with Nothing and report a Arithmetic_Overflow warning. The behaviour in Database backends is not specified and will depend on the particular database - it may cause a hard error, the value may be truncated or wrap-around etc.