Common math functions for SQLite versions before 3.35. Extracted from SQLite 3.35.4 source code (func.c).
Provides following functions:
- rounding:
ceil
,floor
,trunc
; - logarithmic:
ln
,log10
,log2
,log
; - arithmetic:
pow
,sqrt
,mod
; - trigonometric:
cos
,sin
,tan
; - hyperbolic:
cosh
,sinh
,tanh
; - inverse trigonometric:
acos
,asin
,atan
,atan2
; - inverse hyperbolic:
acosh
,asinh
,atanh
; - angular measures:
radians
,degrees
; pi
.
sqlite> .load ./math
sqlite> select sqrt(9);