bigfunctions > generate_dates
generate_dates¶
Signature
generate_dates(start_date, end_date)
Description
Generate a table of dates
Examples
select * from bigfunctions.eu.generate_dates(date('2023-01-01'), date('2023-01-05'))
select * from bigfunctions.us.generate_dates(date('2023-01-01'), date('2023-01-05'))
select * from bigfunctions.europe_west1.generate_dates(date('2023-01-01'), date('2023-01-05'))
+------------+-------------+-------------------+-----------------+-------------------+-----------------+-------------+------------+---------------+-------------+
| date | day_of_week | week_start_monday | week_end_monday | week_start_sunday | week_end_sunday | month_start | month_end | quarter_start | quarter_end |
+------------+-------------+-------------------+-----------------+-------------------+-----------------+-------------+------------+---------------+-------------+
| 2023-01-01 | Sun | 2022-12-26 | 2023-01-01 | 2023-01-01 | 2023-01-07 | 2023-01-01 | 2023-01-31 | 2023-01-01 | 2023-03-31 |
| 2023-01-02 | Mon | 2023-01-02 | 2023-01-08 | 2023-01-01 | 2023-01-07 | 2023-01-01 | 2023-01-31 | 2023-01-01 | 2023-03-31 |
| 2023-01-03 | Tue | 2023-01-02 | 2023-01-08 | 2023-01-01 | 2023-01-07 | 2023-01-01 | 2023-01-31 | 2023-01-01 | 2023-03-31 |
| 2023-01-04 | Wed | 2023-01-02 | 2023-01-08 | 2023-01-01 | 2023-01-07 | 2023-01-01 | 2023-01-31 | 2023-01-01 | 2023-03-31 |
| 2023-01-05 | Thu | 2023-01-02 | 2023-01-08 | 2023-01-01 | 2023-01-07 | 2023-01-01 | 2023-01-31 | 2023-01-01 | 2023-03-31 |
+------------+-------------+-------------------+-----------------+-------------------+-----------------+-------------+------------+---------------+-------------+