Math functions

Abs

class piccolo.query.functions.math.Abs(identifier: Column | QueryString | str, alias: str | None = None)

Absolute value.

Ceil

class piccolo.query.functions.math.Ceil(identifier: Column | QueryString | str, alias: str | None = None)

Nearest integer greater than or equal to argument.

Floor

class piccolo.query.functions.math.Floor(identifier: Column | QueryString | str, alias: str | None = None)

Nearest integer less than or equal to argument.

Round

class piccolo.query.functions.math.Round(identifier: Column | QueryString | str, alias: str | None = None)

Rounds to nearest integer.