abs(-1)
abs(0)
abs(1)
abs(-1.234)
abs(0.0)
abs(4.321)
abs(abs(-1.2) * -1)
# During comparison with H2 and SQLite it expects ceil and floor to be stored as INT values. This casts to resolve.
CAST(ceil(1) AS INT)
CAST(ceil(-1) AS INT)
CAST(ceil(0.0) AS INT)
CAST(ceil(0.4999) AS INT)
CAST(ceil(abs(1)) AS INT)
# CAST(CEIL(2147483647 + 0.6) AS INT) will fail because the cast limits the return to be INT_MAX (21474883647) which is not an H2 or SQLite limitation
exp(0)
exp(1)
exp(-1)
exp(exp(1) + ceil(-1))
CAST(floor(1) AS INT)
CAST(floor(-1) AS INT)
CAST(floor(0.0) AS INT)
CAST(floor(0.4999) AS INT)
CAST(floor(abs(-1)) AS INT)
log(2)
log(2.1)
log(log(2))
log10(2)
log10(2.1)
log10(log10(2))
pi()
power(2, 2)
power(2, -2)
power(2.1, 2)
power(2, -2.1)
power(abs(2), 2)
round(3.4)
round(3.5)
round(3.6)
round(-3.4)
round(-3.5)
round(-3.6)
sign(0)
sign(-1)
sign(1)
sign(abs(1))
sqrt(0)
sqrt(1)
sqrt(1.1)
sqrt(abs(1))
acos(0)
acos(0.5)
acos(-0.5)
acos(1)
acos(-1)
asin(0)
asin(0.5)
asin(-0.5)
asin(1)
asin(-1)
atan(0)
atan(1)
atan(-1)
atan2(2, 1)
atan2(-2, 1)
atan2(2, -1)
atan2(-2, -1)
cos(0)
cos(1.57)
cos(-1.57)
cot(1)
cot(-1)
degrees(0)
degrees(1.57)
degrees(-1.57)
radians(0)
radians(90)
radians(-90)
sin(0)
sin(1.57)
sin(-1.57)
tan(0)
tan(1.57)
tan(-1.57)
dayofmonth('2020-08-26') as dom