Teradata Numeric Functions

FunctionDescriptionReturn TypeParameters
LogarithmicReturns base 10 logarithm of given value.RealNumeric
Natural LogarithmReturns a natural logarithm.RealNumeric
Null If ZeroReturns “null” if the argument is zero, otherwise, returns the argument.RealNumeric
RandomReturns random integerLongLower limit, upper limit
Zero If NullReturns “zero” if the argument is null, otherwise, returns the argument.RealNumeric