PartiQL functions in Amazon QLDB

PDFRSS

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

• AVG

• COUNT

• MAX

• MIN

• SIZE

• SUM

Conditional functions

• COALESCE

• EXISTS

• NULLIF

Date and time functions

• DATE_ADD

• DATE_DIFF

• EXTRACT

• UTCNOW

Scalar functions

• TXID

String functions

• CHAR_LENGTH

• CHARACTER_LENGTH

• LOWER

• SUBSTRING

• TRIM

• UPPER

Data type formatting functions

• CAST

• TO_STRING

• TO_TIMESTAMP