Algebra and Trigonometry Functions

A variety of commonly used math functions are available. They all operate on FLOAT values. SQL Notebook-specific functions are listed below. Refer to the SQLite documentation for the list of SQLite's built-in math functions.

Syntax

ROUND(x)
SIGN(x)

Example

PRINT SIGN(-1.6);  -- "-1"
PRINT ROUND(5.5);  -- "6"