Syntax

integer (*expression*)

**Description
**

The **integer** function returns *expression* converted to an integer.

Table 6-5:integerfunction

Data Type

Conversion

boolean Ifexpressionis true, the result is 1; otherwise the result is 0.

character string

Expressionis converted to an integer with the default formatting set. See Chapter 13,

Formatting Data Valuesfor information about default formatting sets. If the string cannot be converted to aninteger, the result is 0.

date The result is one plus the number of days between

expressionand January 1, 1800.

integer No conversion required.

long No conversion required.

money

Expressionis converted to an integer by truncating any fractional part of the basic currency units(pennies in the U.S.).

real

Expressionis converted to an integer by truncating any fractional part.

time The result is one plus the number of seconds between

expressionand midnight.

**Example
**

integer ("1234.5")