Skip to main content
TO_INTEGER

Converts a value to an integer

Updated over a week ago

Description

The TO_INTEGER() function is used to convert a value, which may be in text or other formats, into an integer. This is useful when you have non-integer data that needs to be treated as whole numbers for calculations or comparisons.

Syntax

TO_INTEGER(value)

Output

integer

Variables

  1. value: The value you want to convert into an integer. This can be a number in text form, a decimal number, or any other compatible data type that can be converted to an integer.

Example

TO_INTEGER(`Score`)

Name

Score

TO_INTEGER

Giacomo

63

63

Kameko

63

63

Anne

36

36

Orlando

83

83

Nasim

35

34

Did this answer your question?