6.8.2.10 Real Function

Syntax

real(expression)

Description

The real function returns expression converted to a real value.

Table 6-9: real function                                                                                    

Data Type  Conversion                                                                                        

                                                                                                            

boolean If expression is true, the result is 1; otherwise the result is 0.                                   

                                                                                                            

character string Expression is converted to a real value with the default formatting set. See Chapter 13,

Formatting Data Values for information about default formatting sets. If the string cannot be converted to a

real value, the result is 0.

                                                                                                            

date The result is one plus the number of days between expression and January 1, 1800.

                                                                                                            

integer No conversion required.

                                                                                                            

long No conversion required.

                                                                                                            

real No conversion required.

                                                                                                            

money Expression is divided by the money decimal place scaling factor in the default formatting set (divided

by 100 in the U.S.); see Chapter 13, Formatting Data Values for more information).

                                                                                                            

time The result is one plus the number of seconds between expression and midnight.

Example

real ("123.45)