PartiQL functions in Amazon QLDB
Important
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.
Note
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
