Functions for MariaDB Xpand 6.1
This page is part of MariaDB's Documentation.
The parent of this page is: Reference for MariaDB Xpand 6.1
Topics on this page:
Overview
MariaDB Xpand includes built-in functions to perform common programming tasks, such as working with strings, numbers, temporal data; Regular Expression (regex) matching; and other data manipulation tasks performed on query result-sets.
Function | Description |
---|---|
Returns the absolute (non-negative) value of the given argument | |
Returns the arc cosine of the given argument | |
Return the sum of two numbers | |
Returns a | |
Returns a | |
Works as a synonym for DATE_ | |
Returns the sum of two | |
Decrypts data using the AES algorithm with the given key | |
Encrypts data using the AES algorithm with the given key | |
Send an email alert | |
Returns a bitwise "and" of two numbers | |
Returns the numeric ASCII value of the leftmost character of the given argument | |
Returns the arc sine of the given argument | |
Returns the arc tangent angle based on a tangent slope's ratio | |
Returns the arc tangent angle based on the length of the opposite and adjacent sides | |
Returns the average of a set of aggregated values | |
Returns a string representation of the binary value of the given | |
Returns a bitwise "and" operation across a set of aggregated numbers | |
Returns the number of bits set in the given argument | |
Returns the length of a string in bits | |
Returns the bitwise "or" operation across a set of numbers | |
Returns the bitwise exclusive-or operation across a set of numbers | |
Return a string that starts with an uppercase letter instead of lowercase | |
Takes a value of one type and converts it to the value of another of type. See CONVERT. | |
See CEILING() | |
Returns the nearest integer value, rounding upwards | |
Returns a string consisting of characters defined by the given code values | |
Returns the number of characters in the given string, counting each multi-byte char as 1 character | |
See CHAR_ | |
Returns | |
Returns the first non-NULL value in the given list and NULL when all values are NULL | |
Compresses the given string and returns the binary string result | |
Concatenates and returns the given string arguments | |
Concatenates and returns the given strings using the specified separator | |
Returns the thread ID for the given connection | |
Converts the given numbers from the first base argument to the second base argument | |
Converts the given value from one character set encoding to another | |
Converts the given | |
Returns the cosine of an angle, specified in radians | |
Returns the cotangent of the given argument | |
Returns the number of values in the given expression | |
Computes a cyclic redundancy check value and returns a 32-bit unsigned value | |
Returns the current date in the currently active timezone | |
See CURDATE() | |
See CURRENT_ | |
See CURTIME() | |
See NOW() | |
Returns the user and host of the current client connection | |
Returns the current time of day in the currently active timezone | |
Returns the name of the default (current) database | |
Returns the date component of the given | |
Performs arithmetic operations on the given date value, adding an | |
Returns a date value as a string using the given format | |
Returns a date with an | |
Calculates the differences in days between two | |
Returns a | |
See DAYOFMONTH() | |
Returns the name of the day of the week for the given date | |
Returns the day of the month in the given date | |
Returns the index for the day of the week of the given | |
Returns the day of the year for the given date, in a range of 1 to 366 | |
Decrypts the string using the given key | |
Converts the given argument from radians to degrees | |
Return the floating point value of one number divided by another | |
Return the integer value of one number divided by another | |
Returns the string that corresponds to the given numeric position in a list of strings | |
Encrypts a string using the given key | |
Encrypts a string with the Unix | |
Returns a boolean indicating if two values are equivalent | |
Returns the value of e, the base of natural logarithms, raised to the given power | |
Returns a string representation of a bits argument using the given values for on and off | |
Returns a non-negative 64-bit random integer | |
Returns the position of the first argument's string in the subsequent string arguments | |
Returns the position of a string in a set of comma-separated substrings | |
Returns the nearest integer value, rounding downwards | |
Returns a formatted number rounded to the specified number of decimal places | |
Returns the number of rows found by the most recent successful | |
Returns the decoded value as binary string of a base-64 encoded string | |
Returns the | |
Returns a date-time value based on a Unix seconds-since-epic numeric value | |
Returns a format string that can be used for rendering dates and time values | |
Attempt to create a user-level lock and return the success status as a boolean | |
Returns the greatest argument from the argument list | |
Returns a concatenated string formed from the arguments | |
Returns a boolean indicating if one value is greater than another | |
Returns a boolean indicating if one value is greater or equal to than another | |
Returns a hexadecimal string representation of the argument | |
Returns the hour for a | |
Returns a boolean indicating if two values are equal | |
Returns one of two values based on a truth expression | |
Returns an alternate value in place of | |
Returns a numeric form of the IPv4 address in string form | |
Returns the string form of an IPv4 address in numeric form | |
Inserts a string in another string at the specified position | |
Returns the position of the first occurrence of a substring in another string | |
Returns the index of the last argument that is less than the first argument or is NULL | |
Returns a boolean to indicate if a named user-level lock is unlocked | |
Returns the connection identifier of the client session that holds a named user-level lock | |
Returns a boolean that indicates if the argument is not | |
Returns a boolean that indicates if the argument is | |
Returns a JSON array created from the argument list | |
Returns a boolean to indicate whether a JSON object contains at least one of the specified JSON paths | |
Returns the maximum depth in terms of inner JSON levels in the JSON data | |
Returns extracted data from some JSON data by applying a path selector | |
Returns the keys of a JSON object as a JSON array | |
Returns the length for an item of JSON data | |
Returns a JSON object created from key/value pairs | |
Returns a double-quoted JSON string from a string argument | |
Returns the JSON path to a query or search string within a JSON object | |
Returns the type of an item of JSON data | |
Transforms a JSON string into the string value that it represents | |
Returns a boolean value to indicate if a string is valid JSON data | |
Returns a date string representing the last day of the month specified by a | |
Returns the value of the most recent auto-generated | |
See LOWER() | |
Returns the argument with the least value from a list of arguments | |
Returns the requested number of leftmost characters in a string | |
Returns the byte length of a string counting each multi-byte char as multiple bytes | |
Returns a boolean indicating if a string value is matched by a wildcard value | |
Returns the natural logarithm of the argument | |
See NOW() | |
See NOW() | |
Returns the position of the first occurrence of a substring within a string | |
Returns the logarithm of a value in either base-e or a specified base | |
Returns the base-2 logarithm of the argument | |
Returns the base-10 logarithm of the argument | |
Returns a string converted to lowercase | |
Returns a string left-padded with the specified characters | |
Returns a boolean indicating if one value is less than another | |
Returns a boolean indicating if one value is less than or equal to another | |
Returns a string with certain leading characters removed | |
Returns a string of comma-separated bit names that are enabled in a bit value | |
Returns a date constructed from the year and day-of-year arguments | |
Returns a time value constructed from separate hour, minute, and second values | |
Returns the maximum value from the aggregated values | |
Returns the MD5 checksum for the given string argument | |
Returns the microseconds from the | |
See SUBSTRING() | |
Returns the minimum value from the aggregated values | |
Returns the minutes for a time | |
Returns the remainder of a division | |
Returns the month number of a date | |
Returns the month name of a date | |
Returns the product of two numbers multiplied together | |
Returns a value with an associated column name | |
Returns a boolean indicating if two values are not equivalent | |
Returns a negated boolean expression | |
Returns a bitwise negated value | |
Returns the current date and time in the currently active timezone | |
Returns a boolean indicating if two values are equivalent, even | |
Returns | |
Returns the octal value of a numerical argument | |
See LENGTH() | |
Returns an encrypted string using the old implementation of | |
Returns a bitwise "or" of two numbers | |
Returns the code value of the leftmost character in the string argument | |
Returns an encrypted string from a plaintext password | |
Adds a number of months to a starting period and returns the result | |
Returns the difference in months between two periods | |
Returns an approximate value of pi | |
See POWER() | |
Returns the value of the first argument raised to the power of the second argument | |
Returns the quarter number for a date | |
Returns a string that is enclosed in single quotes with properly escaped special characters | |
Returns a value converted from degrees to radians | |
Returns a random non-negative floating-point number less than 1 | |
Returns a boolean indicating if a string value is matched by a regular expression | |
Returns a boolean to indicate if a named user-level lock was released | |
Returns a string repeated the specified number of times | |
Replaces all occurrences of one string with another and returns the resulting string | |
Returns a string with all the characters reversed | |
Returns the requested number of rightmost characters in a string | |
Returns a number rounded to the requested number of decimal places | |
Returns the number of rows updated, inserted, or deleted by the preceding statement | |
Returns a string right-padded with the specified characters | |
Returns a string with certain trailing characters removed | |
See DATABASE() | |
Returns the time value derived from the number of seconds since midnight | |
Returns the seconds from a given time | |
See USER() | |
See SHA1() | |
Returns an SHA-1 checksum hash as a hexadecimal string | |
Returns an SHA-2 checksum hash as a hexadecimal string | |
Returns a number with its bits shifted to the left | |
Returns a number with its bits shifted to the right | |
Returns the sign of the argument | |
Returns the sine of an angle, specified in radians | |
Sleeps for the requested number of seconds | |
Returns the Soundex representation of a string | |
Returns a string consisting of the requested number of space characters | |
Returns the square of a number | |
Returns the square root of a number | |
See STDDEV_ | |
See STDDEV_ | |
Returns the population standard deviation of the aggregated values | |
Returns the sample standard deviation of the aggregated values | |
Parses a string argument using the supplied format and returns a | |
Parses a string argument using the supplied format and returns a | |
Parses a string argument using the supplied format and returns a | |
Returns | |
Returns the second argument subtracted from the first argument | |
Returns a date with a count of units subtracted | |
Returns a | |
Works as a synonym for DATE_ | |
See SUBSTRING() | |
Returns a substring of the first argument given a character position and optional length | |
Returns a substring that is deliniated by finding one or more delimiter strings | |
Subtracts a | |
Returns the sum of the aggregated values | |
Returns the system date and time | |
Returns the system date and time in the requested time zone | |
Returns the current authenticating username and hostname | |
Returns the tangent of an angle, specified in radians | |
Returns the time part of a time-containing expression | |
Returns a time string in the specified format | |
Returns a time value converted into a count of seconds since midnight | |
Returns the difference between two | |
Return a | |
Adds the given number of units to the | |
Returns an integer count of how far apart the date arguments are in the requested units | |
Returns a base-64 encoded representation of a string | |
Returns the number of days since year 0 for a given date | |
Returns the provided string with its leading and/or trailing space characters removed | |
Returns a number truncated to the requested number of decimal places | |
Returns a string describing the type of a value | |
See UPPER() | |
Uncompresses and returns the string argument | |
Returns the uncompressed length of the given compressed string | |
Returns a binary string based on one or more pairs of hexadecimal digits | |
Returns a time as a number of seconds since the Unix epoch began | |
Returns a string with removed surrounding quotes and removed backslash escapes | |
Returns a string converted to uppercase | |
Returns the current authenticating username and hostname | |
Returns the current date in the UTC timezone | |
Returns the current time of day in the UTC timezone | |
Returns the current date and time in the UTC timezone | |
Returns a unique value of Universal Unique Identifier | |
Returns a "short" universal identifier as a 64-bit unsigned integer | |
Used in the | |
Returns the population variance across a set of aggregated values | |
Returns the sample variance across a set of aggregated values | |
See VAR_ | |
Returns the version of the MariaDB server as a string | |
Returns the week number for a date | |
Returns the week day index for a date | |
Returns the calendar-week number for a date | |
Returns a bitwise exclusive "or" of two numbers | |
Returns the year for the given date | |
Returns the year and week number for a date |