Standard Functions

MindsDB supports standard SQL functions via DuckDB and MySQL engines.

DuckDB Functions

MindsDB executes functions on the underlying DuckDB engine. Therefore, all DuckDB functions are supported within MindsDB out of the box.

• Aggregate Functions
• Array Functions
• Bitstring Functions
• Blob Functions
• Date Format Functions
• Date Functions
• Date Part Functions
• Enum Functions
• Interval Functions
• Lambda Functions
• List Functions
• Map Functions
• Nested Functions
• Numeric Functions
• Pattern Matching
• Regular Expressions
• Struct Functions
• Text Functions
• Time Functions
• Timestamp Functions
• Timestamp with Time Zone Functions
• Union Functions
• Utility Functions
• Window Functions

MySQL Functions

MindsDB executes MySQL-style functions on the underlying DuckDB engine. The following functions have been adapted to MySQL-style functions.

String functions:

• CHAR
• FORMAT
• INSTR
• LENGTH
• LOCATE
• SUBSTRING_INDEX
• UNHEX

Date and time functions:

• ADDDATE
• ADDTIME
• CONVERT_TZ
• CURDATE
• CURTIME
• DATE_ADD
• DATE_FORMAT
• DATE_SUB
• DATEDIFF
• DAYNAME
• DAYOFMONTH
• DAYOFWEEK
• DAYOFYEAR
• EXTRACT
• FROM_DAYS
• FROM_UNIXTIME
• GET_FORMAT
• TIMESTAMPDIFF

Other functions:

• REGEXP_SUBSTR
• SHA2