CAST_ARR_INT
Written by
Updated at June 27, 2023
Syntax
CAST_ARR_INT( array )
Description
Converts array to an array of integers. The conversion rules are the same as for INT.
Argument types:
array—Array of fractional numbers | Array of integers | Array of strings
Return type: Array of integers
Example
| [string_array] | [float_array] | CAST_ARR_INT([string_array]) | CAST_ARR_INT([float_array]) |
|---|---|---|---|
"['100','300','200']" |
'[12.3,0.43,42]' |
'[100,300,200]' |
'[12,0,42]' |
"['100','300',NULL,NULL]" |
'[0,NULL,12]' |
'[100,300,NULL,NULL]' |
'[0,NULL,12]' |
"['150',NULL,'192']" |
'[3.2,2.3,3.5]' |
'[150,NULL,192]' |
'[3,2,3]' |
Data source support
ClickHouse 21.8, PostgreSQL 9.3.