16.20 - Result Type and Attributes - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K
The results take the sign of the dividend:
  • MOD (-17, 4) = -1
  • MOD (-17, -4) = -1
  • MOD (17, -4) = 1
  • MOD (17, 4) = 1