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 command-line interface:
sqlite> .load ./math
sqlite> select sqrt(9);
See How to Install an Extension for usage with IDE, Python, etc.