Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Compatibility Functions


Mimer SQL implements functions according to the SQL-2016 standard. To simplify migration to Mimer SQL, the syntax alternatives listed below are also supported.

Alternative syntax
Regular Mimer SQL syntax
CONCAT(str1, str2)
str1 || str2
DAY(expr)
EXTRACT(DAY FROM expr)
DAYOFMONTH(expr)
EXTRACT(DAY FROM expr)
HOUR(expr)
EXTRACT(HOUR FROM expr)
IFNULL(expr1, expr2)
COALESCE(expr1, expr2)
INSERT(str1, n1, n2, str2)
PASTE(str1, n1, n2, str2)
LCASE(str)
LOWER(str)
LEFT(str,n)
SUBSTRING(str FROM n)
LENGTH(str)
CHAR_LENGTH(str)
LOCATE(str1, str2)
POSITION(str1 IN str2)
LTRIM(chr, str)
TRIM(LEADING chr FROM str)
LTRIM(str)
TRIM(LEADING FROM str)
MINUTE(expr)
EXTRACT(MINUTE FROM expr)
MONTH(expr)
EXTRACT(MONTH FROM expr)
POSITION(str1, str2)
POSITION(str1 IN str2)
RIGHT(str, n)
TAIL(str, n)
RTRIM(chr, str)
TRIM(TRAILING chr FROM str)
RTRIM(str)
TRIM(TRAILING FROM str)
SECOND(expr)
EXTRACT(SECOND FROM expr)
SPACE(n)
REPEAT(' ', n)
SUBSTRING(str, n)
SUBSTRING(str FROM n)
SUBSTRING(str, n1, n2)
SUBSTRING(str FROM n1 FOR n2)
UCASE(str)
UPPER(str)
YEAR(expr)
EXTRACT(YEAR FROM expr)


Mimer
Mimer Information Technology AB
Phone: +46 18 780 92 00
info@mimer.com
Mimer SQL Documentation TOC PREV NEXT INDEX