12 | | ||ABS()||Returns the absolute value.||X||X||X||X||[https://github.com/django/django/pull/9577 9577]|| |
13 | | ||ACOS()||Returns the arccosine.||X||X||X||-||-|| |
14 | | ||ASIN()||Returns the arcsine.||X||X||X||-||-|| |
15 | | ||ATAN()||Returns the arctangent.||X||X||X||-||-|| |
16 | | ||ATAN2()||Returns the arctangent of the two variables passed to it.||X||X||X||-||-|| |
17 | | ||CEILING()||Returns the smallest integer value that is not less than a numeric expression||X||as CEIL()||X||-||-|| |
18 | | ||COS()||Returns the cosine expressed in radians.||X||X||X||-||-|| |
19 | | ||COT()||Returns the cotangent.||X||X||X||-||-|| |
20 | | ||DEGREES()||Returns a numeric expression converted from radians to degrees.||X||X||X||-||-|| |
21 | | ||EXP()||Returns the base of the natural logarithm (e) raised to the power of a numeric expression.||X||X||X||-||-|| |
22 | | ||FLOOR()||Returns the largest integer value that is not greater than a numeric expression.||X||X||X||-||-|| |
23 | | ||LOG()||Returns the natural logarithm of a numeric expression.||X||X||X||-||-|| |
24 | | ||MOD()||Returns the remainder of one expression by diving by another expression.||X||X||X||-||-|| |
25 | | ||PI()||Returns the value of pi||X||-||X||-||-|| |
26 | | ||POWER()||Returns the value of one expression raised to the power of another expression||X||X||X||-||-|| |
27 | | ||RADIANS()||Returns the value of an expression converted from degrees to radians.||X||X||X||-||-|| |
28 | | ||ROUND()||Returns a numeric expression rounded to an integer.\\Can be used to round an expression to a number of decimal points||X||X||X||X||-|| |
29 | | ||SIN()||Returns the sine given in radians.||X||X||X||-||-|| |
30 | | ||SQRT()||Returns the square root.||X||X||X||-||-|| |
31 | | ||TAN()||Returns the tangent expressed in radians.||X||X||X||-||-|| |
| 12 | ||{{{ABS}}}||Returns the absolute value.||✔||✔||✔||✔||[https://github.com/django/django/pull/9577 9577], [https://github.com/django/django/pull/9622 9622]|| |
| 13 | ||{{{ACOS}}}||Returns the arccosine.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 14 | ||{{{ASIN}}}||Returns the arcsine.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 15 | ||{{{ATAN}}}||Returns the arctangent.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 16 | ||{{{ATAN2}}}||Returns the arctangent of the two variables passed to it.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 17 | ||{{{CEILING}}}||Returns the smallest integer value that is not less than a numeric expression||✔||{{{CEIL}}}||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 18 | ||{{{COS}}}||Returns the cosine expressed in radians.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 19 | ||{{{COT}}}||Returns the cotangent.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 20 | ||{{{DEGREES}}}||Returns a numeric expression converted from radians to degrees.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 21 | ||{{{EXP}}}||Returns the base of the natural logarithm (e) raised to the power of a numeric expression.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 22 | ||{{{FLOOR}}}||Returns the largest integer value that is not greater than a numeric expression.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 23 | ||{{{LOG}}}||Returns the natural logarithm of a numeric expression.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 24 | ||{{{MOD}}}||Returns the remainder of one expression by diving by another expression.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 25 | ||{{{PI}}}||Returns the value of π||✔||-||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 26 | ||{{{POWER}}}||Returns the value of one expression raised to the power of another expression||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 27 | ||{{{RADIANS}}}||Returns the value of an expression converted from degrees to radians.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 28 | ||{{{ROUND}}}||Returns a numeric expression rounded to an integer.\\Can be used to round an expression to a number of decimal points||✔||✔||✔||✔||[https://github.com/django/django/pull/9622 9622]|| |
| 29 | ||{{{SIN}}}||Returns the sine given in radians.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 30 | ||{{{SQRT}}}||Returns the square root.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
| 31 | ||{{{TAN}}}||Returns the tangent expressed in radians.||✔||✔||✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]|| |
34 | | ||ASCII() (In Python, it is ord())||Returns numeric value of left-most character||X||X||X||as UNICODE()||[https://github.com/django/django/pull/9583 9583]|| |
35 | | ||CHR()||Character with the given code||X||X||as CHAR()||as CHAR()||[https://github.com/django/django/pull/9583 9583]|| |
36 | | ||LEFT()||Returns the leftmost number of characters as specified||X||as SUBSTR()||X||as SUBSTR()||[https://github.com/django/django/pull/9583 9583]|| |
37 | | ||LPAD()||Returns the string argument, left-padded with the specified string||X||X||X||-||-|| |
38 | | ||LTRIM()||Removes leading spaces||X||X||X||X||[https://github.com/django/django/pull/9220 9220]|| |
39 | | ||MD5()||Calculates the MD5 hash of string, returning the result in hexadecimal||X||-||-||-||-|| |
40 | | ||REPEAT()||Repeats a string the specified number of times||X||-||X||-||-|| |
41 | | ||REPLACE()||Replaces occurrences of a specified string||X||X||X||X||[https://github.com/django/django/pull/9539 9539]|| |
42 | | ||REVERSE()||Reverse the characters in a string||X||-||X||-||-|| |
43 | | ||RIGHT()||Returns the specified rightmost number of characters||X||as SUBSTR()||X||as SUBSTR()||[https://github.com/django/django/pull/9583 9583]|| |
44 | | ||RPAD()||Appends string the specified number of times||X||X||X||-||-|| |
45 | | ||RTRIM()||Removes trailing spaces||X||X||X||X||[https://github.com/django/django/pull/9220 9220]|| |
46 | | ||TRIM()||Removes leading and trailing spaces||X||X||X||X||[https://github.com/django/django/pull/9220 9220]|| |
| 34 | ||{{{ASCII}}}||Returns numeric value of left-most character. (Equivalent to {{{ord()}}} in Python.)||✔||✔||✔||{{{UNICODE}}}||[https://github.com/django/django/pull/9583 9583]|| |
| 35 | ||{{{CHR}}}||Character with the given code||✔||✔||{{{CHAR}}}||{{{CHAR}}}||[https://github.com/django/django/pull/9583 9583]|| |
| 36 | ||{{{LEFT}}}||Returns the leftmost number of characters as specified||✔||✔**^2^**||✔||✔**^2^**||[https://github.com/django/django/pull/9583 9583]|| |
| 37 | ||{{{LPAD}}}||Returns the string argument, left-padded with the specified string||✔||✔||✔||-||-|| |
| 38 | ||{{{LTRIM}}}||Removes leading spaces||✔||✔||✔||✔||[https://github.com/django/django/pull/9220 9220]|| |
| 39 | ||{{{MD5}}}||Calculates the MD5 hash of string, returning the result in hexadecimal||✔||-||-||✔**^1^**||-|| |
| 40 | ||{{{REPEAT}}}||Repeats a string the specified number of times||✔||-||✔||-||-|| |
| 41 | ||{{{REPLACE}}}||Replaces occurrences of a specified string||✔||✔||✔||✔||[https://github.com/django/django/pull/9539 9539] [[span(style=font-size:75%, (Merged))]]|| |
| 42 | ||{{{REVERSE}}}||Reverse the characters in a string||✔||-||✔||✔**^1^**||-|| |
| 43 | ||{{{RIGHT}}}||Returns the specified rightmost number of characters||✔||✔**^2^**||✔||✔**^2^**||[https://github.com/django/django/pull/9583 9583]|| |
| 44 | ||{{{RPAD}}}||Appends string the specified number of times||✔||✔||✔||-||-|| |
| 45 | ||{{{RTRIM}}}||Removes trailing spaces||✔||✔||✔||✔||[https://github.com/django/django/pull/9220 9220]|| |
| 46 | ||{{{TRIM}}}||Removes leading and trailing spaces||✔||✔||✔||✔||[https://github.com/django/django/pull/9220 9220]|| |
| 47 | |
| 48 | - **^1^** Function can be easily supported on SQLite with a [https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_function user defined function]. |
| 49 | - **^2^** Behaviour can be emulated by using {{{SUBSTR}}}. |