Examples: Representative Function Expressions

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

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following are representative function expressions and results.

Expression Result
COS(5-4) 5.40302305868140E -001
SIN(LOG(0.5)) -2.96504042171437E -001
SIN(RADIANS(180.0)) 1.22464679914735E-016
TAN(ABS(-3)) -1.42546543074278E -001
ACOS(-0.5) 2.09439510239320E 000
ASIN(1) 1.57079632679490E 000
ATAN(1+2) 1.24904577239825E 000
ATAN2(1,1) 7.85398163397448E -001