PartiQL functions in Amazon QLDB - Amazon Quantum Ledger Database (Amazon QLDB)

PartiQL functions in Amazon QLDB


End of support notice: Existing customers will be able to use Amazon QLDB until end of support on 07/31/2025. For more details, see Migrate an Amazon QLDB Ledger to Amazon Aurora PostgreSQL.

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


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

This function reference is based on the PartiQL documentation Built-in Functions.

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