# Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

## SQLite round() function

Description

SQLite round() function rounds a floating-point value t up to a number of digits to the right of the decimal point. If the 2nd argument (rounded digits) is omitted, it is assumed to be 0.

Syntax

```round(X)
round(X,Y)
```

SQLite Version : 3.8.5

Argument

Name Description
X A number which will be rounded upto D decimal places.
Y A number indicating up to how many decimal places N will be rounded.

Note : The arguments can be zero(0) or negative. The default value of ‘Y’ is 0 if not specified. if ‘Y’ is 0, the round will happen from the left of the ‘Y’ decimal point of the value ‘X’.

Example of SQLite round() function

1. SELECT round(59.9,0);

Here is the result.

```round(59.9,0)
-------------
60.0
```

The above SQLite statement will round the given number 59.9. No decimal places have been defined, so the default decimal value is 0.

Example : round() function with negative value

1. SELECT round(-59.9,0);

Here is the result.

```round(-59.9,0)
--------------
-60.0
```

The above SQLite statement will round the given number -59.9. No decimal places have been defined, so the default decimal value is 0.

Example : round() function using decimal places

1. SELECT round(-4.535,2);

Here is the result.

```round(-4.535,2)
---------------
-4.54
```

The above SQLite statement will round the given number -4.535 up to 2 decimal places.

Example : round() function using negative decimal places

1. SELECT round(34.4158,-1);

Here is the result.

```round(34.4158,-1)
-----------------
34.0```

The above SQLite statement will round the given number 34.4158 from the left of decimal place up to 1 place.