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

6.6 KiB

Raw Permalink Blame History

pmod

This function is used to return the positive value of the remainder after division of x by y.

Syntax

pmod(INT a, INT b)

Parameters

**Table 1** Parameters
Parameter	Mandatory	Type	Description
a	Yes	DOUBLE, BIGINT, DECIMAL, or STRING	The value can be a float, integer, or string.
b	Yes	DOUBLE, BIGINT, DECIMAL, or STRING	The value can be a float, integer, or string.

Return Values

The return value is of the DECIMAL or INT type.

If the value of a or b is NULL, NULL is returned.
If the value of b is 0, NULL is returned.

Example Code

The value 2 is returned.

select pmod(2,5);

The value 3 is returned.

select pmod (-2,5) (parse: -2=5* (-1)...3);

The value NULL is returned.

select pmod(5,0);

The value 1 is returned.

select pmod(5,2);

The value 0.877 is returned.

select pmod(5.123,2.123);

Parent topic: Mathematical Functions

6.6 KiB Raw Permalink Blame History