round

Retrieve a random floating-point number

Syntax

round(arith_expr)

Arguments

arith_expr

An arithmetic expression.

Description

This scalar numeric function retrieves a random floating-point number (between 0.0 and 1.0) using the specified integer as the seed. If 0 is specified, the rand function retrieves the next random floating-point number for the current seed.