ARRAY_SORT

Returns the values in the array in ascending order.

Syntax

ARRAY_SORT(array)

Arguments

array

Type: any

An array of any value types.

Returns

Type: same as input but in ascending order.

Examples

input	output
[2, 1, 3]	[1, 2, 3]
['b', 'a', 'cd', 'cc']	['a', 'b', 'cc', 'cd']
[0.5, 1.0, 0.75, 1.5]	[0.5, 0.75, 1.0, 1.5]
null::string	null
[true, false, true]	[false, true, true]
[date '2023-04-01', date '2023-04-01', date '2023-05-02']	[date '2023-04-01', date '2023-04-01', date '2023-05-02']
[timestamp '2023-01-02 11:00:00', timestamp '2023-01-01 09:00:00', timestamp '2023-01-01 10:00:00']	[timestamp '2023-01-01 09:00:00', timestamp '2023-01-01 10:00:00', timestamp '2023-01-02 11:00:00']