FIXED(a,p,s) is an arithmetic function that is used to output the expression a (a number) in a format of the data type FIXED(p,s) (p, s are unsigned integers).

Digits after the decimal point are rounded to s decimal places, if necessary.

Result of the FIXED(a,p,s) Function

s not specified

Result as for s=0

p not specified

Result as for p=38


Special NULL value

a is the NULL value

NULL value

a is special NULL value

Special NULL value