MOD - Firebolt Documentation

Reference sql
Explicit Transactions
Data types
Information schema
Operators
SQL commands
SQL functions
- Overview
- Functions glossary
- Aggregation functions
- Array functions
- Binary functions
- Conditional and miscellaneous functions
- DataSketches functions
- Date and time functions
- Geospatial functions
- JSON functions
- Lambda functions
- Numeric functions
- Session functions
- String functions
- Table-valued functions
- Vector functions
- Window functions

On this page

Syntax
Parameters
Return Type
Example

Calculates the remainder after dividing two values, <value_n> / <value_d>.

Syntax

MOD(<value_n>,<value_d>)

Parameters

Parameter	Description	Supported input types
`<value_n>`	The numerator of the division equation	`INT`, `BIGINT`
`<value_d>`	The denominator of the division equation	`INT`, `BIGINT`

Return Type

BIGINT if one of the inputs is BIGINT. INT, otherwise.

Example

The following example returns the remainder of 45 divided by 7: