Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

4.8 KiB

Raw Permalink Blame History

floor

This function is used to round down a to the nearest integer.

Syntax

floor(DOUBLE a)

Parameters

**Table 1** Parameter
Parameter	Mandatory	Type	Description
a	Yes	DOUBLE, BIGINT, DECIMAL, or STRING	The value can be a float, integer, or string. If the value is not of the DOUBLE type, the system will implicitly convert it to the DOUBLE type for calculation.

Return Values

The return value is of the BIGINT type.

If the value of a is NULL, NULL is returned.

Example Code

The value 1 is returned.

select floor(1.2);

The value -2 is returned.

select floor(-1.2);

The value NULL is returned.

select floor(null);

Parent topic: Mathematical Functions

4.8 KiB Raw Permalink Blame History