16.20 - Examples: Representative Function Expressions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2020-03-25
dita:mapPath
xzf1512079057909.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
kby1472250656485

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