Functions

Jump to bottom

Andrey Gershun edited this page May 25, 2015 · 11 revisions

Functions

Compile-time standard library

String functions
Number functions
Logical functions
Date-time functions
- CONVERT()

Run-time standard library

ROWNUM() (or ROW_NUMBER())
COALESCE()

[User-defined functions](User-defined functions)
Into-functions
From-functions
Aggregators
[User-defined aggregators](User-defined aggregators)

Samples:

    ABS(), IIF(), IFNULL(), INSTR(), LOWER(), 
    UPPER(), LCASE(), UCASE(), LEN(), LENGTH()
    YEAR(date), DAYOFWEEK(date)

Compatibility function

OBJECT_ID()

© 2014-2024, Andrey Gershun & Mathias Rangel Wulff

Please help improve the documentation by opening a PR on the wiki repo

Quick links

Clone this wiki locally