BigQuery - 将日期数组转换为字符串

标题: 将日期数组转换为字符串的BigQuery操作

sql
WITH dates AS (
  SELECT DATE '2023-01-01' AS date_val
  UNION ALL
  SELECT DATE '2023-01-02' AS date_val
  UNION ALL
  SELECT DATE '2023-01-03' AS date_val
  -- Add more dates as needed
)
SELECT ARRAY_AGG(date_val ORDER BY date_val) AS date_array
FROM dates;

sql
WITH dates AS (
  SELECT DATE '2023-01-01' AS date_val
  UNION ALL
  SELECT DATE '2023-01-02' AS date_val
  UNION ALL
  SELECT DATE '2023-01-03' AS date_val
  -- Add more dates as needed
)
SELECT ARRAY_TO_STRING(ARRAY_AGG(CAST(date_val AS STRING) ORDER BY date_val), ', ') AS date_string
FROM dates;