Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
Numeric functions
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
In addition to the arithmetic expressions discussed previously, jOOQ also supports a variety of numeric functions. As discussed in the chapter about SQL dialects numeric functions (as any function type) are mostly emulated in your database, in case they are not natively supported.
Table of contents
- 3.8.10.1.
- ABS
- 3.8.10.2.
- ACOS
- 3.8.10.3.
- ASIN
- 3.8.10.4.
- ATAN
- 3.8.10.5.
- ATAN2
- 3.8.10.6.
- CEIL
- 3.8.10.7.
- COS
- 3.8.10.8.
- COSH
- 3.8.10.9.
- COT
- 3.8.10.10.
- COTH
- 3.8.10.11.
- DEG
- 3.8.10.12.
- E
- 3.8.10.13.
- EXP
- 3.8.10.14.
- FLOOR
- 3.8.10.15.
- GREATEST
- 3.8.10.16.
- LEAST
- 3.8.10.17.
- LN
- 3.8.10.18.
- LOG
- 3.8.10.19.
- LOG10 (new)
- 3.8.10.20.
- NEG
- 3.8.10.21.
- PI
- 3.8.10.22.
- POWER
- 3.8.10.23.
- RAD
- 3.8.10.24.
- RAND
- 3.8.10.25.
- ROUND
- 3.8.10.26.
- SIGN
- 3.8.10.27.
- SIN
- 3.8.10.28.
- SINH
- 3.8.10.29.
- SQRT
- 3.8.10.30.
- SQUARE (new)
- 3.8.10.31.
- TAN
- 3.8.10.32.
- TANH
- 3.8.10.33.
- TRUNC
- 3.8.10.34.
- WIDTH_BUCKET
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!