Functions for MariaDB Xpand

This page is part of MariaDB's Documentation.

The parent of this page is: Reference for MariaDB Xpand

Topics on this page:

Overview

Overview

A summary of functions across MariaDB Xpand versions:

Function	In 23.09?	In 6.1?	In 6.0?	In 5.3?
ABS()	23.09	6.1	6.0	5.3
ACOS()	23.09	6.1	6.0	5.3
ADD()	23.09	6.1	6.0	5.3
ADDDATE()	23.09	6.1	6.0	5.3
ADDTIME()	23.09	6.1	6.0	5.3
ADD_DATE_INTERVAL()	23.09	6.1	6.0	5.3
ADD_TIME_INTERVAL()	23.09	6.1	6.0	5.3
AES_DECRYPT()	23.09	6.1	6.0	5.3
AES_ENCRYPT()	23.09	6.1	6.0	5.3
ALERT()	23.09	6.1	6.0	5.3
ANDBITS()	23.09	6.1	6.0	5.3
ASCII()	23.09	6.1	6.0	5.3
ASIN()	23.09	6.1	6.0	5.3
ATAN()	23.09	6.1	6.0	5.3
ATAN2()	23.09	6.1	6.0	5.3
AVG()	23.09	6.1	6.0	5.3
BIN()	23.09	6.1	6.0	5.3
BIT_AND()	23.09	6.1	6.0	5.3
BIT_COUNT()	23.09	6.1	6.0	5.3
BIT_LENGTH()	23.09	6.1	6.0	5.3
BIT_OR()	23.09	6.1	6.0	5.3
BIT_XOR()	23.09	6.1	6.0	5.3
CAPITALIZE()	23.09	6.1	6.0	5.3
CAST()	23.09	6.1	6.0	5.3
CAST_NULL_ON_ERR()	23.09	6.1
CEIL()	23.09	6.1	6.0	5.3
CEILING()	23.09	6.1	6.0	5.3
CHAR()	23.09	6.1	6.0	5.3
CHARACTER_LENGTH()	23.09	6.1	6.0	5.3
CHAR_LENGTH()	23.09	6.1	6.0	5.3
CMP()	23.09	6.1	6.0	5.3
COALESCE()	23.09	6.1	6.0	5.3
COMPRESS()	23.09	6.1	6.0	5.3
CONCAT()	23.09	6.1	6.0	5.3
CONCAT_WS()	23.09	6.1	6.0	5.3
CONNECTION_ID()	23.09	6.1	6.0	5.3
CONV()	23.09	6.1	6.0	5.3
CONVERT()	23.09	6.1	6.0	5.3
CONVERT_TZ()	23.09	6.1	6.0	5.3
COS()	23.09	6.1	6.0	5.3
COT()	23.09	6.1	6.0	5.3
COUNT()	23.09	6.1	6.0	5.3
CRC32()	23.09	6.1	6.0	5.3
CURDATE()	23.09	6.1	6.0	5.3
CURRENT_DATE()	23.09	6.1	6.0	5.3
CURRENT_ROLE()	23.09	6.1	6.0	5.3
CURRENT_TIME()	23.09	6.1	6.0	5.3
CURRENT_TIMESTAMP()	23.09	6.1	6.0	5.3
CURRENT_USER()	23.09	6.1	6.0	5.3
CURTIME()	23.09	6.1	6.0	5.3
DATABASE()	23.09	6.1	6.0	5.3
DATE()	23.09	6.1	6.0	5.3
DATEDIFF()	23.09	6.1	6.0	5.3
DATETIME_TRUNC()	23.09	6.1	6.0	5.3
DATE_ADD()	23.09	6.1	6.0	5.3
DATE_FORMAT()	23.09	6.1	6.0	5.3
DATE_SUB()	23.09	6.1	6.0	5.3
DAY()	23.09	6.1	6.0	5.3
DAYNAME()	23.09	6.1	6.0	5.3
DAYOFMONTH()	23.09	6.1	6.0	5.3
DAYOFWEEK()	23.09	6.1	6.0	5.3
DAYOFYEAR()	23.09	6.1	6.0	5.3
DECODE()	23.09	6.1	6.0	5.3
DEGREES()	23.09	6.1	6.0	5.3
DIVFLT()	23.09	6.1	6.0	5.3
DIVINT()	23.09	6.1	6.0	5.3
ELT()	23.09	6.1	6.0	5.3
ENCODE()	23.09	6.1	6.0	5.3
ENCRYPT()	23.09	6.1	6.0	5.3
EQ()	23.09	6.1	6.0	5.3
EXP()	23.09	6.1	6.0	5.3
EXPORT_SET()	23.09	6.1	6.0	5.3
FASTRAND()	23.09	6.1	6.0	5.3
FIELD()	23.09	6.1	6.0	5.3
FIND_IN_SET()	23.09	6.1	6.0	5.3
FLOOR()	23.09	6.1	6.0	5.3
FORMAT()	23.09	6.1	6.0	5.3
FOUND_ROWS()	23.09	6.1	6.0	5.3
FROM_BASE64()	23.09	6.1	6.0	5.3
FROM_DAYS()	23.09	6.1	6.0	5.3
FROM_UNIXTIME()	23.09	6.1	6.0	5.3
GET_FORMAT()	23.09	6.1	6.0	5.3
GET_LOCK()	23.09	6.1	6.0	5.3
GREATEST()	23.09	6.1	6.0	5.3
GROUP_CONCAT()	23.09	6.1	6.0	5.3
GT()	23.09	6.1	6.0	5.3
GTEQ()	23.09	6.1	6.0	5.3
HEX()	23.09	6.1	6.0	5.3
HOUR()	23.09	6.1	6.0	5.3
IDENTICAL()	23.09	6.1	6.0	5.3
IF()	23.09	6.1	6.0	5.3
IFNULL()	23.09	6.1	6.0	5.3
INET_ATON()	23.09	6.1	6.0	5.3
INET_NTOA()	23.09	6.1	6.0	5.3
INSERT()	23.09	6.1	6.0	5.3
INSTR()	23.09	6.1	6.0	5.3
INTERVAL()	23.09	6.1	6.0	5.3
ISNOTNULL()	23.09	6.1	6.0	5.3
ISNULL()	23.09	6.1	6.0	5.3
IS_FREE_LOCK()	23.09	6.1	6.0	5.3
IS_USED_LOCK()	23.09	6.1	6.0	5.3
JSON_ARRAY()	23.09	6.1	6.0	5.3
JSON_CONTAINS_PATH()	23.09	6.1	6.0	5.3
JSON_DEPTH()	23.09	6.1	6.0	5.3
JSON_EXTRACT()	23.09	6.1	6.0	5.3
JSON_KEYS()	23.09	6.1	6.0	5.3
JSON_LENGTH()	23.09	6.1	6.0	5.3
JSON_OBJECT()	23.09	6.1	6.0	5.3
JSON_QUOTE()	23.09	6.1	6.0	5.3
JSON_SEARCH()	23.09	6.1	6.0	5.3
JSON_TYPE()	23.09	6.1	6.0	5.3
JSON_UNQUOTE()	23.09	6.1	6.0	5.3
JSON_VALID()	23.09	6.1	6.0	5.3
LAST_DAY()	23.09	6.1	6.0	5.3
LAST_INSERT_ID()	23.09	6.1	6.0	5.3
LCASE()	23.09	6.1	6.0	5.3
LEAST()	23.09	6.1	6.0	5.3
LEFT()	23.09	6.1	6.0	5.3
LENGTH()	23.09	6.1	6.0	5.3
LIKE()	23.09	6.1	6.0	5.3
LN()	23.09	6.1	6.0	5.3
LOCALTIME()	23.09	6.1	6.0	5.3
LOCALTIMESTAMP()	23.09	6.1	6.0	5.3
LOCATE()	23.09	6.1	6.0	5.3
LOG()	23.09	6.1	6.0	5.3
LOG2()	23.09	6.1	6.0	5.3
LOG10()	23.09	6.1	6.0	5.3
LOWER()	23.09	6.1	6.0	5.3
LPAD()	23.09	6.1	6.0	5.3
LT()	23.09	6.1	6.0	5.3
LTEQ()	23.09	6.1	6.0	5.3
LTRIM()	23.09	6.1	6.0	5.3
MAKEDATE()	23.09	6.1	6.0	5.3
MAKETIME()	23.09	6.1	6.0	5.3
MAKE_SET()	23.09	6.1	6.0	5.3
MAX()	23.09	6.1	6.0	5.3
MD5()	23.09	6.1	6.0	5.3
MICROSECOND()	23.09	6.1	6.0	5.3
MID()	23.09	6.1	6.0	5.3
MIN()	23.09	6.1	6.0	5.3
MINUTE()	23.09	6.1	6.0	5.3
MOD()	23.09	6.1	6.0	5.3
MONTH()	23.09	6.1	6.0	5.3
MONTHNAME()	23.09	6.1	6.0	5.3
MUL()	23.09	6.1	6.0	5.3
NAME_CONST()	23.09	6.1	6.0	5.3
NEQ()	23.09	6.1	6.0	5.3
NOT()	23.09	6.1	6.0	5.3
NOTBITS()	23.09	6.1	6.0	5.3
NOW()	23.09	6.1	6.0	5.3
NULLEQ()	23.09	6.1	6.0	5.3
NULLIF()	23.09	6.1	6.0	5.3
OCT()	23.09	6.1	6.0	5.3
OCTET_LENGTH()	23.09	6.1	6.0	5.3
OLD_PASSWORD()	23.09	6.1	6.0	5.3
ORBITS()	23.09	6.1	6.0	5.3
ORD()	23.09	6.1	6.0	5.3
PASSWORD()	23.09	6.1	6.0	5.3
PERIOD_ADD()	23.09	6.1	6.0	5.3
PERIOD_DIFF()	23.09	6.1	6.0	5.3
PI()	23.09	6.1	6.0	5.3
POW()	23.09	6.1	6.0	5.3
POWER()	23.09	6.1	6.0	5.3
QUARTER()	23.09	6.1	6.0	5.3
QUOTE()	23.09	6.1	6.0	5.3
RADIANS()	23.09	6.1	6.0	5.3
RAND()	23.09	6.1	6.0	5.3
REGEXP()	23.09	6.1	6.0	5.3
RELEASE_LOCK()	23.09	6.1	6.0	5.3
REPEAT()	23.09	6.1	6.0	5.3
REPLACE()	23.09	6.1	6.0	5.3
REVERSE()	23.09	6.1	6.0	5.3
RIGHT()	23.09	6.1	6.0	5.3
ROUND()	23.09	6.1	6.0	5.3
ROW_COUNT()	23.09	6.1	6.0	5.3
RPAD()	23.09	6.1	6.0	5.3
RTRIM()	23.09	6.1	6.0	5.3
SCHEMA()	23.09	6.1	6.0	5.3
SECOND()	23.09	6.1	6.0	5.3
SEC_TO_TIME()	23.09	6.1	6.0	5.3
SESSION_USER()	23.09	6.1	6.0	5.3
SHA()	23.09	6.1	6.0	5.3
SHA1()	23.09	6.1	6.0	5.3
SHA2()	23.09	6.1	6.0	5.3
SHIFTL()	23.09	6.1	6.0	5.3
SHIFTR()	23.09	6.1	6.0	5.3
SIGN()	23.09	6.1	6.0	5.3
SIN()	23.09	6.1	6.0	5.3
SLEEP()	23.09	6.1	6.0	5.3
SOUNDEX()	23.09	6.1	6.0	5.3
SPACE()	23.09	6.1	6.0	5.3
SQR()	23.09	6.1	6.0	5.3
SQRT()	23.09	6.1	6.0	5.3
STD()	23.09	6.1	6.0	5.3
STDDEV()	23.09	6.1	6.0	5.3
STDDEV_POP()	23.09	6.1	6.0	5.3
STDDEV_SAMP()	23.09	6.1	6.0	5.3
STRCMP()	23.09	6.1	6.0	5.3
STR_TO_DATE()	23.09	6.1	6.0	5.3
STR_TO_DATE_DATE()	23.09	6.1	6.0	5.3
STR_TO_DATE_TIME()	23.09	6.1	6.0	5.3
SUB()	23.09	6.1	6.0	5.3
SUBDATE()	23.09	6.1	6.0	5.3
SUBSTR()	23.09	6.1	6.0	5.3
SUBSTRING()	23.09	6.1	6.0	5.3
SUBSTRING_INDEX()	23.09	6.1	6.0	5.3
SUBTIME()	23.09	6.1	6.0	5.3
SUB_DATE_INTERVAL()	23.09	6.1	6.0	5.3
SUB_TIME_INTERVAL()	23.09	6.1	6.0	5.3
SUM()	23.09	6.1	6.0	5.3
SYSDATE()	23.09	6.1	6.0	5.3
SYSDATE_TZ()	23.09	6.1	6.0	5.3
SYSTEM_USER()	23.09	6.1	6.0	5.3
TAN()	23.09	6.1	6.0	5.3
TIME()	23.09	6.1	6.0	5.3
TIMEDIFF()	23.09	6.1	6.0	5.3
TIMESTAMP()	23.09	6.1	6.0	5.3
TIMESTAMPADD()	23.09	6.1	6.0	5.3
TIMESTAMPDIFF()	23.09	6.1	6.0	5.3
TIME_FORMAT()	23.09	6.1	6.0	5.3
TIME_TO_SEC()	23.09	6.1	6.0	5.3
TO_BASE64()	23.09	6.1	6.0	5.3
TO_DAYS()	23.09	6.1	6.0	5.3
TRIM()	23.09	6.1	6.0	5.3
TRUNCATE()	23.09	6.1	6.0	5.3
TYPEOF()	23.09	6.1	6.0	5.3
UCASE()	23.09	6.1	6.0	5.3
UNCOMPRESS()	23.09	6.1	6.0	5.3
UNCOMPRESSED_LENGTH()	23.09	6.1	6.0	5.3
UNHEX()	23.09	6.1	6.0	5.3
UNIX_TIMESTAMP()	23.09	6.1	6.0	5.3
UNQUOTE()	23.09	6.1	6.0	5.3
UPPER()	23.09	6.1	6.0	5.3
USER()	23.09	6.1	6.0	5.3
UTC_DATE()	23.09	6.1	6.0	5.3
UTC_TIME()	23.09	6.1	6.0	5.3
UTC_TIMESTAMP()	23.09	6.1	6.0	5.3
UUID()	23.09	6.1	6.0	5.3
UUID_SHORT()	23.09	6.1	6.0	5.3
VALUES()	23.09	6.1	6.0	5.3
VARIANCE()	23.09	6.1	6.0	5.3
VAR_POP()	23.09	6.1	6.0	5.3
VAR_SAMP()	23.09	6.1	6.0	5.3
VERSION()	23.09	6.1	6.0	5.3
WEEK()	23.09	6.1	6.0	5.3
WEEKDAY()	23.09	6.1	6.0	5.3
WEEKOFYEAR()	23.09	6.1	6.0	5.3
XORBITS()	23.09	6.1	6.0	5.3
YEAR()	23.09	6.1	6.0	5.3
YEARWEEK()	23.09	6.1	6.0	5.3

Function	In 6.0?	In 5.3?
ABS()	6.0	5.3
ACOS()	6.0	5.3
ADD()	6.0	5.3
ADDDATE()	6.0	5.3
ADDTIME()	6.0	5.3
ADD_DATE_INTERVAL()	6.0	5.3
ADD_TIME_INTERVAL()	6.0	5.3
AES_DECRYPT()	6.0	5.3
AES_ENCRYPT()	6.0	5.3
ALERT()	6.0	5.3
ANDBITS()	6.0	5.3
ASCII()	6.0	5.3
ASIN()	6.0	5.3
ATAN()	6.0	5.3
ATAN2()	6.0	5.3
AVG()	6.0	5.3
BIN()	6.0	5.3
BIT_AND()	6.0	5.3
BIT_COUNT()	6.0	5.3
BIT_LENGTH()	6.0	5.3
BIT_OR()	6.0	5.3
BIT_XOR()	6.0	5.3
CAPITALIZE()	6.0	5.3
CAST()	6.0	5.3
CEIL()	6.0	5.3
CEILING()	6.0	5.3
CHAR()	6.0	5.3
CHARACTER_LENGTH()	6.0	5.3
CHAR_LENGTH()	6.0	5.3
CMP()	6.0	5.3
COALESCE()	6.0	5.3
COMPRESS()	6.0	5.3
CONCAT()	6.0	5.3
CONCAT_WS()	6.0	5.3
CONNECTION_ID()	6.0	5.3
CONV()	6.0	5.3
CONVERT()	6.0	5.3
CONVERT_TZ()	6.0	5.3
COS()	6.0	5.3
COT()	6.0	5.3
COUNT()	6.0	5.3
CRC32()	6.0	5.3
CURDATE()	6.0	5.3
CURRENT_DATE()	6.0	5.3
CURRENT_ROLE()	6.0	5.3
CURRENT_TIME()	6.0	5.3
CURRENT_TIMESTAMP()	6.0	5.3
CURRENT_USER()	6.0	5.3
CURTIME()	6.0	5.3
DATABASE()	6.0	5.3
DATE()	6.0	5.3
DATEDIFF()	6.0	5.3
DATETIME_TRUNC()	6.0	5.3
DATE_ADD()	6.0	5.3
DATE_FORMAT()	6.0	5.3
DATE_SUB()	6.0	5.3
DAY()	6.0	5.3
DAYNAME()	6.0	5.3
DAYOFMONTH()	6.0	5.3
DAYOFWEEK()	6.0	5.3
DAYOFYEAR()	6.0	5.3
DECODE()	6.0	5.3
DEGREES()	6.0	5.3
DIVFLT()	6.0	5.3
DIVINT()	6.0	5.3
ELT()	6.0	5.3
ENCODE()	6.0	5.3
ENCRYPT()	6.0	5.3
EQ()	6.0	5.3
EXP()	6.0	5.3
EXPORT_SET()	6.0	5.3
FASTRAND()	6.0	5.3
FIELD()	6.0	5.3
FIND_IN_SET()	6.0	5.3
FLOOR()	6.0	5.3
FORMAT()	6.0	5.3
FOUND_ROWS()	6.0	5.3
FROM_BASE64()	6.0	5.3
FROM_DAYS()	6.0	5.3
FROM_UNIXTIME()	6.0	5.3
GET_FORMAT()	6.0	5.3
GET_LOCK()	6.0	5.3
GREATEST()	6.0	5.3
GROUP_CONCAT()	6.0	5.3
GT()	6.0	5.3
GTEQ()	6.0	5.3
HEX()	6.0	5.3
HOUR()	6.0	5.3
IDENTICAL()	6.0	5.3
IF()	6.0	5.3
IFNULL()	6.0	5.3
INET_ATON()	6.0	5.3
INET_NTOA()	6.0	5.3
INSERT()	6.0	5.3
INSTR()	6.0	5.3
INTERVAL()	6.0	5.3
ISNOTNULL()	6.0	5.3
ISNULL()	6.0	5.3
IS_FREE_LOCK()	6.0	5.3
IS_USED_LOCK()	6.0	5.3
JSON_ARRAY()	6.0	5.3
JSON_CONTAINS_PATH()	6.0	5.3
JSON_DEPTH()	6.0	5.3
JSON_EXTRACT()	6.0	5.3
JSON_KEYS()	6.0	5.3
JSON_LENGTH()	6.0	5.3
JSON_OBJECT()	6.0	5.3
JSON_QUOTE()	6.0	5.3
JSON_SEARCH()	6.0	5.3
JSON_TYPE()	6.0	5.3
JSON_UNQUOTE()	6.0	5.3
JSON_VALID()	6.0	5.3
LAST_DAY()	6.0	5.3
LAST_INSERT_ID()	6.0	5.3
LCASE()	6.0	5.3
LEAST()	6.0	5.3
LEFT()	6.0	5.3
LENGTH()	6.0	5.3
LIKE()	6.0	5.3
LN()	6.0	5.3
LOCALTIME()	6.0	5.3
LOCALTIMESTAMP()	6.0	5.3
LOCATE()	6.0	5.3
LOG()	6.0	5.3
LOG2()	6.0	5.3
LOG10()	6.0	5.3
LOWER()	6.0	5.3
LPAD()	6.0	5.3
LT()	6.0	5.3
LTEQ()	6.0	5.3
LTRIM()	6.0	5.3
MAKEDATE()	6.0	5.3
MAKETIME()	6.0	5.3
MAKE_SET()	6.0	5.3
MAX()	6.0	5.3
MD5()	6.0	5.3
MICROSECOND()	6.0	5.3
MID()	6.0	5.3
MIN()	6.0	5.3
MINUTE()	6.0	5.3
MOD()	6.0	5.3
MONTH()	6.0	5.3
MONTHNAME()	6.0	5.3
MUL()	6.0	5.3
NAME_CONST()	6.0	5.3
NEQ()	6.0	5.3
NOT()	6.0	5.3
NOTBITS()	6.0	5.3
NOW()	6.0	5.3
NULLEQ()	6.0	5.3
NULLIF()	6.0	5.3
OCT()	6.0	5.3
OCTET_LENGTH()	6.0	5.3
OLD_PASSWORD()	6.0	5.3
ORBITS()	6.0	5.3
ORD()	6.0	5.3
PASSWORD()	6.0	5.3
PERIOD_ADD()	6.0	5.3
PERIOD_DIFF()	6.0	5.3
PI()	6.0	5.3
POW()	6.0	5.3
POWER()	6.0	5.3
QUARTER()	6.0	5.3
QUOTE()	6.0	5.3
RADIANS()	6.0	5.3
RAND()	6.0	5.3
REGEXP()	6.0	5.3
RELEASE_LOCK()	6.0	5.3
REPEAT()	6.0	5.3
REPLACE()	6.0	5.3
REVERSE()	6.0	5.3
RIGHT()	6.0	5.3
ROUND()	6.0	5.3
ROW_COUNT()	6.0	5.3
RPAD()	6.0	5.3
RTRIM()	6.0	5.3
SCHEMA()	6.0	5.3
SECOND()	6.0	5.3
SEC_TO_TIME()	6.0	5.3
SESSION_USER()	6.0	5.3
SHA()	6.0	5.3
SHA1()	6.0	5.3
SHA2()	6.0	5.3
SHIFTL()	6.0	5.3
SHIFTR()	6.0	5.3
SIGN()	6.0	5.3
SIN()	6.0	5.3
SLEEP()	6.0	5.3
SOUNDEX()	6.0	5.3
SPACE()	6.0	5.3
SQR()	6.0	5.3
SQRT()	6.0	5.3
STD()	6.0	5.3
STDDEV()	6.0	5.3
STDDEV_POP()	6.0	5.3
STDDEV_SAMP()	6.0	5.3
STRCMP()	6.0	5.3
STR_TO_DATE()	6.0	5.3
STR_TO_DATE_DATE()	6.0	5.3
STR_TO_DATE_TIME()	6.0	5.3
SUB()	6.0	5.3
SUBDATE()	6.0	5.3
SUBSTR()	6.0	5.3
SUBSTRING()	6.0	5.3
SUBSTRING_INDEX()	6.0	5.3
SUBTIME()	6.0	5.3
SUB_DATE_INTERVAL()	6.0	5.3
SUB_TIME_INTERVAL()	6.0	5.3
SUM()	6.0	5.3
SYSDATE()	6.0	5.3
SYSDATE_TZ()	6.0	5.3
SYSTEM_USER()	6.0	5.3
TAN()	6.0	5.3
TIME()	6.0	5.3
TIMEDIFF()	6.0	5.3
TIMESTAMP()	6.0	5.3
TIMESTAMPADD()	6.0	5.3
TIMESTAMPDIFF()	6.0	5.3
TIME_FORMAT()	6.0	5.3
TIME_TO_SEC()	6.0	5.3
TO_BASE64()	6.0	5.3
TO_DAYS()	6.0	5.3
TRIM()	6.0	5.3
TRUNCATE()	6.0	5.3
TYPEOF()	6.0	5.3
UCASE()	6.0	5.3
UNCOMPRESS()	6.0	5.3
UNCOMPRESSED_LENGTH()	6.0	5.3
UNHEX()	6.0	5.3
UNIX_TIMESTAMP()	6.0	5.3
UNQUOTE()	6.0	5.3
UPPER()	6.0	5.3
USER()	6.0	5.3
UTC_DATE()	6.0	5.3
UTC_TIME()	6.0	5.3
UTC_TIMESTAMP()	6.0	5.3
UUID()	6.0	5.3
UUID_SHORT()	6.0	5.3
VALUES()	6.0	5.3
VARIANCE()	6.0	5.3
VAR_POP()	6.0	5.3
VAR_SAMP()	6.0	5.3
VERSION()	6.0	5.3
WEEK()	6.0	5.3
WEEKDAY()	6.0	5.3
WEEKOFYEAR()	6.0	5.3
XORBITS()	6.0	5.3
YEAR()	6.0	5.3
YEARWEEK()	6.0	5.3

Function	In 6.1?
ABS()	6.1
ACOS()	6.1
ADD()	6.1
ADDDATE()	6.1
ADDTIME()	6.1
ADD_DATE_INTERVAL()	6.1
ADD_TIME_INTERVAL()	6.1
AES_DECRYPT()	6.1
AES_ENCRYPT()	6.1
ALERT()	6.1
ANDBITS()	6.1
ASCII()	6.1
ASIN()	6.1
ATAN()	6.1
ATAN2()	6.1
AVG()	6.1
BIN()	6.1
BIT_AND()	6.1
BIT_COUNT()	6.1
BIT_LENGTH()	6.1
BIT_OR()	6.1
BIT_XOR()	6.1
CAPITALIZE()	6.1
CAST()	6.1
CAST_NULL_ON_ERR()	6.1
CEIL()	6.1
CEILING()	6.1
CHAR()	6.1
CHARACTER_LENGTH()	6.1
CHAR_LENGTH()	6.1
CMP()	6.1
COALESCE()	6.1
COMPRESS()	6.1
CONCAT()	6.1
CONCAT_WS()	6.1
CONNECTION_ID()	6.1
CONV()	6.1
CONVERT()	6.1
CONVERT_TZ()	6.1
COS()	6.1
COT()	6.1
COUNT()	6.1
CRC32()	6.1
CURDATE()	6.1
CURRENT_DATE()	6.1
CURRENT_ROLE()	6.1
CURRENT_TIME()	6.1
CURRENT_TIMESTAMP()	6.1
CURRENT_USER()	6.1
CURTIME()	6.1
DATABASE()	6.1
DATE()	6.1
DATEDIFF()	6.1
DATETIME_TRUNC()	6.1
DATE_ADD()	6.1
DATE_FORMAT()	6.1
DATE_SUB()	6.1
DAY()	6.1
DAYNAME()	6.1
DAYOFMONTH()	6.1
DAYOFWEEK()	6.1
DAYOFYEAR()	6.1
DECODE()	6.1
DEGREES()	6.1
DIVFLT()	6.1
DIVINT()	6.1
ELT()	6.1
ENCODE()	6.1
ENCRYPT()	6.1
EQ()	6.1
EXP()	6.1
EXPORT_SET()	6.1
FASTRAND()	6.1
FIELD()	6.1
FIND_IN_SET()	6.1
FLOOR()	6.1
FORMAT()	6.1
FOUND_ROWS()	6.1
FROM_BASE64()	6.1
FROM_DAYS()	6.1
FROM_UNIXTIME()	6.1
GET_FORMAT()	6.1
GET_LOCK()	6.1
GREATEST()	6.1
GROUP_CONCAT()	6.1
GT()	6.1
GTEQ()	6.1
HEX()	6.1
HOUR()	6.1
IDENTICAL()	6.1
IF()	6.1
IFNULL()	6.1
INET_ATON()	6.1
INET_NTOA()	6.1
INSERT()	6.1
INSTR()	6.1
INTERVAL()	6.1
ISNOTNULL()	6.1
ISNULL()	6.1
IS_FREE_LOCK()	6.1
IS_USED_LOCK()	6.1
JSON_ARRAY()	6.1
JSON_CONTAINS_PATH()	6.1
JSON_DEPTH()	6.1
JSON_EXTRACT()	6.1
JSON_KEYS()	6.1
JSON_LENGTH()	6.1
JSON_OBJECT()	6.1
JSON_QUOTE()	6.1
JSON_SEARCH()	6.1
JSON_TYPE()	6.1
JSON_UNQUOTE()	6.1
JSON_VALID()	6.1
LAST_DAY()	6.1
LAST_INSERT_ID()	6.1
LCASE()	6.1
LEAST()	6.1
LEFT()	6.1
LENGTH()	6.1
LIKE()	6.1
LN()	6.1
LOCALTIME()	6.1
LOCALTIMESTAMP()	6.1
LOCATE()	6.1
LOG()	6.1
LOG2()	6.1
LOG10()	6.1
LOWER()	6.1
LPAD()	6.1
LT()	6.1
LTEQ()	6.1
LTRIM()	6.1
MAKEDATE()	6.1
MAKETIME()	6.1
MAKE_SET()	6.1
MAX()	6.1
MD5()	6.1
MICROSECOND()	6.1
MID()	6.1
MIN()	6.1
MINUTE()	6.1
MOD()	6.1
MONTH()	6.1
MONTHNAME()	6.1
MUL()	6.1
NAME_CONST()	6.1
NEQ()	6.1
NOT()	6.1
NOTBITS()	6.1
NOW()	6.1
NULLEQ()	6.1
NULLIF()	6.1
OCT()	6.1
OCTET_LENGTH()	6.1
OLD_PASSWORD()	6.1
ORBITS()	6.1
ORD()	6.1
PASSWORD()	6.1
PERIOD_ADD()	6.1
PERIOD_DIFF()	6.1
PI()	6.1
POW()	6.1
POWER()	6.1
QUARTER()	6.1
QUOTE()	6.1
RADIANS()	6.1
RAND()	6.1
REGEXP()	6.1
RELEASE_LOCK()	6.1
REPEAT()	6.1
REPLACE()	6.1
REVERSE()	6.1
RIGHT()	6.1
ROUND()	6.1
ROW_COUNT()	6.1
RPAD()	6.1
RTRIM()	6.1
SCHEMA()	6.1
SECOND()	6.1
SEC_TO_TIME()	6.1
SESSION_USER()	6.1
SHA()	6.1
SHA1()	6.1
SHA2()	6.1
SHIFTL()	6.1
SHIFTR()	6.1
SIGN()	6.1
SIN()	6.1
SLEEP()	6.1
SOUNDEX()	6.1
SPACE()	6.1
SQR()	6.1
SQRT()	6.1
STD()	6.1
STDDEV()	6.1
STDDEV_POP()	6.1
STDDEV_SAMP()	6.1
STRCMP()	6.1
STR_TO_DATE()	6.1
STR_TO_DATE_DATE()	6.1
STR_TO_DATE_TIME()	6.1
SUB()	6.1
SUBDATE()	6.1
SUBSTR()	6.1
SUBSTRING()	6.1
SUBSTRING_INDEX()	6.1
SUBTIME()	6.1
SUB_DATE_INTERVAL()	6.1
SUB_TIME_INTERVAL()	6.1
SUM()	6.1
SYSDATE()	6.1
SYSDATE_TZ()	6.1
SYSTEM_USER()	6.1
TAN()	6.1
TIME()	6.1
TIMEDIFF()	6.1
TIMESTAMP()	6.1
TIMESTAMPADD()	6.1
TIMESTAMPDIFF()	6.1
TIME_FORMAT()	6.1
TIME_TO_SEC()	6.1
TO_BASE64()	6.1
TO_DAYS()	6.1
TRIM()	6.1
TRUNCATE()	6.1
TYPEOF()	6.1
UCASE()	6.1
UNCOMPRESS()	6.1
UNCOMPRESSED_LENGTH()	6.1
UNHEX()	6.1
UNIX_TIMESTAMP()	6.1
UNQUOTE()	6.1
UPPER()	6.1
USER()	6.1
UTC_DATE()	6.1
UTC_TIME()	6.1
UTC_TIMESTAMP()	6.1
UUID()	6.1
UUID_SHORT()	6.1
VALUES()	6.1
VARIANCE()	6.1
VAR_POP()	6.1
VAR_SAMP()	6.1
VERSION()	6.1
WEEK()	6.1
WEEKDAY()	6.1
WEEKOFYEAR()	6.1
XORBITS()	6.1
YEAR()	6.1
YEARWEEK()	6.1