View on GitHub

JODA - JSON On Demand Analysis

Efficient data wrangling for semi-structured JSON documents

INT - Cast

Casts/Parses the given value to integer

Input parameters

Name Type Optional Description
x Any False Value to convert to integer

Output

Number: The integer point representation of the given value. Nothing: if it can not be converted.

Usage

INT(<x>)

Examples

Example 1

Input Document

1
5.3
5.6
"  -123  "
true
false

Query

LOAD tmp
AS ('': INT(''))

Result

1
5
5
-123
1
0