PartiQL functions - Amazon Quantum Ledger Database (Amazon QLDB)

PartiQL functions

PartiQL in Amazon QLDB supports the following built-in variants of SQL standard functions.


Any SQL functions that are not included in this list are not currently supported in QLDB.

Unknown type (null and missing) propagation

Unless otherwise stated, all of these functions propagate null and missing argument values. Propagation of NULL or MISSING is defined as returning NULL if any function argument is either NULL or MISSING. The following are examples of this propagation.

CHAR_LENGTH(null) -- null CHAR_LENGTH(missing) -- null (also returns null)

Aggregate functions

Conditional functions

Date and time functions

Scalar functions

String functions

Data type formatting functions