ARRAY_SORT
最終更新日時: 2026/09/15配列内の値を昇順で返します。
構文
ARRAY_SORT(array)
引数
array
型: any
任意の型の値の配列。
戻り値
型: 入力と同じですが、昇順です。
例
| array | 出力 |
|---|---|
| [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"] |