Functions | Flowmap City

📄️ Bitstring Functions

This section describes functions and operators for examining and manipulating bit values.

📄️ Blob Functions

This section describes functions and operators for examining and manipulating blob values.

📄️ Text Functions

This section describes functions and operators for examining and manipulating string values. ␣ denotes a space character.

📄️ Date Functions

This section describes functions and operators for examining and manipulating date values.

The strftime and strptime functions can be used to convert between dates/timestamps and strings. This is often required when parsing CSV files, displaying output to the user or transferring information between programs. Because there are many possible date representations, these functions accept a format string that describes how the date or timestamp should be structured.

📄️ Date Parts

The datepart and datediff and date_trunc functions can be used to manipulate the fields of temporal types.

📄️ Enum Functions

This section describes functions and operators for examining and manipulating ENUM values.

📄️ Interval Functions

This section describes functions and operators for examining and manipulating INTERVAL values.

📄️ Nested Functions

This section describes functions and operators for examining and manipulating nested values. There are three nested data types: lists, structs, and maps.