meta data for this page
  •  

F_RAND

input/output-compatibility to ib_udf

Entrypoint f_rand compatible with UTF-8

Inputs/Outputs

   Input      without
   Output     DOUBLE	       floatingpoint-random-number with value between 0 and 1

Syntax

   This function can create more than one different random-no. in one second because the generator is set with the actual systemtime and the process-ID, 
   so that is is impossible, that 2 calls in the same second return the same random-no.
   TestSQL
   SELECT F_RAND() FROM RDB$DATABASE;