INT

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

Syntax 

INT(<number, string, Boolean, date>)

Description

Rounds a number down to the nearest integer. INT accepts null values.

Converts integers contained in a string, Boolean values, or dates into the integer data field type. When using Boolean values, true is converted into 1, and false is converted into 0. Dates are converted into milliseconds (returning the difference between the current time and midnight, January 1, 1970 UTC).

Examples

Data field typeColumn1INT() returns
float4.74
float-4.7-5
string5555
string55.2<error>
Booleantrue1
Booleanfalse0
dateOct 15, 2010 04:34:34 AM1,287,110,074,000
dateSep 25, 2010 12:33:25 PM1,285,410,805,000
big_integer9,999,999,999,999,999,999<error>