Source: https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/data-types/numeric-type/
Documentation version: v5.3.2

# Numeric types

GQL supports integers, floating-point numbers, and arbitrary-precision numbers. Integers can be signed or unsigned, while floating-point numbers and arbitrary-precision numbers are always signed.

Signed numbers can be positive, negative, or zero, and are by default positive if no sign is specified. Unsigned numbers are always non-negative.

## Signed integers

A signed integer is either non-negative (positive or zero) or negative.

The following table lists the signed integer types and their value ranges.

 | Type | Declared keywords | Range
 | INT64 | `INT` and `INT64` | -9,223,372,036,854,775,808 ~ 9,223,372,036,854,775,807
 | INT32 | `INT32` | -2,147,483,648 ~ 2,147,483,647
 | INT16 | `INT16` | -32,768 ~ 32,767
 | INT8 | `INT8` | -128 ~ 127

## Unsigned integers

An unsigned integer is always non-negative.

The following table lists the unsigned integer types and their value ranges.

 | Type | Declared keywords | Range
 | UINT64 | `UINT` and `UINT64` | 0 ~ 18,446,744,073,709,551,615
 | UINT32 | `UINT32` | 0 ~ 4,294,967,295
 | UINT16 | `UINT16` | 0 ~ 65,535
 | UINT8 | `UINT8` | 0 ~ 255

## Floating-point numbers

Both single-precision floating-point format (FLOAT) and double-precision floating-point format (DOUBLE) are supported.

 | Type | Declared keywords | Range
 | FLOAT32 | `FLOAT32`, `FLOAT` | 3.4E +/- 38
 | FLOAT64 | `FLOAT64`, `DOUBLE` | 1.7E +/- 308

Scientific notation is also supported, such as `1e2`, `1.1e2`, `.3e4`, `1.e4`, and `-1234E-10`.

### Special values

`FLOAT` (`FLOAT32`) and `DOUBLE` (`FLOAT64`) types support the following special values:

 | Expression | Description | Type
 | `1.0f/0.0`, `1.0d/0.0` | Positive infinity | `FLOAT` / `DOUBLE`
 | `-1.0f/0.0`, `-1.0d/0.0` | Negative infinity | `FLOAT` / `DOUBLE`
 | `0.0f/0.0`, `0.0d/0.0` | Not a number | `FLOAT` / `DOUBLE`

Note

The `f` and `d` indicate types `FLOAT` (`FLOAT32`) and `DOUBLE` (`FLOAT64`) respectively.

These special values can also be created by casting from strings. For more information, see [Conversions of special values](https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/fe/expressions/cast/#conversions_of_special_values).

## Arbitrary-precision numbers

Arbitrary-precision numbers are used to store a large number of digits where exactness is required.

### Syntax

diagramsource

 arbitrary_precision_number  

````
arbitrary_precision_number ::=
    ( 'DECIMAL' | 'DEC' ) (precision (',' scale)? )?

````

The precision is the total count of digits in the whole number and has a range of 1 to 256.

The scale is the count of digits to the right of the decimal point and has a range of 0 to 128. The scale must be no larger than the precision.

#### Default values

If neither the precision nor the scale is specified, the precision defaults to 10 and the scale defaults to 0.

If only the precision is specified, the scale defaults to 0.

#### Rules

If the declared precision and scale are the same, only decimals whose absolute values are less than 1 can be stored. For example, `DECIMAL(3, 3)` can only store values in the range of -0.999 to 0.999.

If the count of digits to the left of the decimal point is greater than the difference between the declared precision and scale, an error is returned. For example, if the declared precision is 4 and the declared scale is 2, the value 123.4 cannot be stored.

If the count of digits to the right of the decimal point is greater than the declared scale, the value is rounded to the declared scale. For example, if the declared precision is 4 and the declared scale is 2, the value 1.234 is stored as 1.23.

If the count of digits to the right of the decimal point is smaller than the declared scale, zeros are padded to the right of the value to match the declared scale. For example, if the declared precision is 4 and the declared scale is 2, the value 12.3 is displayed as 12.30.

## Declaration examples

Example 1:

````
'''
CREATE GRAPH TYPE IF NOT EXISTS person AS 
    { NODE Person 
        ( { 
            id INT64 PRIMARY KEY,  
            salary DECIMAL(10, 4) DEFAULT 10000.00M,  
            is_adult BOOL DEFAULT TRUE,  
            name STRING DEFAULT 'John Doe',  
            hobbies LIST<STRING> DEFAULT ['reading', 'swimming'], 
            birthday DATE DEFAULT DATE('1990-01-01') 
        } ) 
    }
'''

````

In the preceding example, the property `id` is of the integer type (`INT64`) and the property `salary` is of the arbitrary-precision type (`DECIMAL(10, 4)`).

Example 2:

````
'''
CREATE GRAPH TYPE IF NOT EXISTS person2 AS  
    { NODE Person 
        ( { 
            id INT64 PRIMARY KEY,  
            salary DECIMAL 
        } ) 
    }
'''

````

In the preceding example, the property `salary` is of the arbitrary-precision type (`DECIMAL`) with the default precision and scale of 10 and 0, respectively.

## More information

[Numeric literals](https://dev-docs.nebula-graph.io/v5.3.2/database-gql-reference/fe/literals/#numeric_literals)