在Google Big Query查询中赋值日期变量

DECLARE date_variable DATE;
SET date_variable = DATE('YYYY-MM-DD');

DECLARE start_date DATE;
SET start_date = DATE('2022-01-01');

SELECT *
FROM your_table
WHERE date_column >= start_date;

DECLARE start_date DATE;
DECLARE end_date DATE;
SET start_date = DATE('2022-01-01');
SET end_date = DATE('2022-12-31');

SELECT DATE_DIFF(end_date, start_date, DAY) AS date_diff;