The long function returns expression converted to a long integer.
Table 6-6: long 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 long integer 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
long integer, 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.
money Expression is converted to a long integer by truncating any fractional part of the basic currency units
(pennies in the U.S.).
real Expression is converted to a long integer by truncating any fractional part.
time The result is one plus the number of seconds between expression and midnight.