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

CURRENT_TIMESTAMP

EXP

EXTRACT

FLOOR

INITCAP

LN

LOCALTIME

LOCALTIMESTAMP

LOG10

LOWER

MOD

NULLIF

OVERLAY

POSITION

POWER

SUBSTRING, SUBSTRING Regex, SUBSTRING with Escape

SYSTEM_USER

TRIM

UPPER