Scalar Functions

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions >

Scalar Functions

Previous pageReturn to chapter overviewNext page

Scalar functions are single-row functions (that is, they produce a single result for each input row to a query). The following scalar functions are available in streaming SQL:

ABS
CAST
CEIL / CEILING
CHAR_LENGTH / CHARACTER_LENGTH
COALESCE
CURRENT_DATE
CURRENT_PATH
CURRENT_ROW_TIMESTAMP
EXP
EXTRACT
FLOOR
INITCAP
LN
LOCALTIME
LOCALTIMESTAMP
LOG10
LOWER
MOD
NULLIF
OVERLAY
POSITION
POWER
SUBSTRING
SYSTEM_USER
TRIM
UPPER