时间戳

首页 > 解决方案 > BigQuery：创建具有指定范围日期的数组

google-bigquery - BigQuery：创建具有指定范围日期的数组

问题描述

有谁知道如何在 BigQuery 中创建一个包含指定范围日期的数组（创建日期只需要开始和结束日期），如下所示：

[CURRENT_DATE(), DATE_ADD(CURRENT_DATE(), INTERVAL 1 DAY), DATE_ADD(CURRENT_DATE(), INTERVAL 2 DAY), DATE_ADD(CURRENT_DATE(), INTERVAL 3 DAY), DATE_ADD(CURRENT_DATE(), INTERVAL 4 DAY), DATE_ADD(CURRENT_DATE(), INTERVAL 5 DAY)]

标签： google-bigquery

解决方案

这应该有效。

select generate_date_array("2021-05-01", "2021-05-30") as date_array

输出 JSON

[
  {
    "date_array": [
      "2021-05-01",
      "2021-05-02",
      "2021-05-03",
      "2021-05-04",
      "2021-05-05",
      "2021-05-06",
      "2021-05-07",
      "2021-05-08",
      "2021-05-09",
      "2021-05-10",
      "2021-05-11",
      "2021-05-12",
      "2021-05-13",
      "2021-05-14",
      "2021-05-15",
      "2021-05-16",
      "2021-05-17",
      "2021-05-18",
      "2021-05-19",
      "2021-05-20",
      "2021-05-21",
      "2021-05-22",
      "2021-05-23",
      "2021-05-24",
      "2021-05-25",
      "2021-05-26",
      "2021-05-27",
      "2021-05-28",
      "2021-05-29",
      "2021-05-30"
    ]
  }
]

推荐阅读