RAND()

<< POWER() | FB 2.5 Language Reference | RDB$GET_CONTEXT() >>
<< POWER() | FB 2.1 Language Reference | RDB$GET_CONTEXT() >>

RAND()

Available in: DSQL, PSQL

Added in: 2.1

Description

Returns a random number between 0 and 1.

Result type: DOUBLE PRECISION

Syntax

 RAND ()

Important: If the external function RAND is declared in your database, it will override the internal function. To make the internal function available, DROP or ALTER the external function (UDF).

back to top of page
<< POWER() | FB 2.5 Language Reference | RDB$GET_CONTEXT() >>
<< POWER() | FB 2.1 Language Reference | RDB$GET_CONTEXT() >>