1.0

Syntax
RADIANS ( number )
RANDOM function
The RANDOM function returns a random number.
The RANDOM function returns a DOUBLE PRECISION on page 578 number with positive sign, greater than
or equal to zero (0), and less than one (1.0).
Syntax
RANDOM()
RAND function
The RAND function returns a random number given a seed number
The RAND function returns a DOUBLE PRECISION on page 578 number with positive sign, greater than or
equal to zero (0), and less than one (1.0), given an INTEGER on page 579 seed number.
Syntax
RAND( seed )
RTRIM function
RTRIM removes blanks from the end of a character string expression.
Syntax
RTRIM(CharacterExpression)
A CharacterExpression is a CHAR, VARCHAR, or LONG VARCHAR data type, any built-in type that is
implicitly converted to a string.
RTRIM returns NULL if CharacterExpression evaluates to null.
Examples
-- returns ' asdf'
VALUES RTRIM(' asdf ')
-- returns 'asdf'
VALUES RTRIM('asdf ')
SECOND function
The SECOND function returns the seconds part of a value.
The argument must be a time, timestamp, or a valid character string representation of a time or timestamp that
is not a CLOB, LONG VARCHAR, or XML value. The result of the function is an integer between 0 and 59.
If the argument can be null, the result can be null. If the argument is null, the result is 0.
Syntax
SECOND ( expression )
535
SQL Language Reference