在不同日期格式的Big Query中查询多个表

SELECT *
FROM `project.dataset.table1`, `project.dataset.table2`
WHERE date_column >= '2022-01-01' AND date_column <= '2022-01-31'

SELECT *
FROM `project.dataset.table1`, `project.dataset.table2`
WHERE UNIX_SECONDS(date_column) >= UNIX_SECONDS('2022-01-01') AND UNIX_SECONDS(date_column) <= UNIX_SECONDS('2022-01-31')

SELECT *
FROM `project.dataset.table1`, `project.dataset.table2`
WHERE DATE(FORMAT_TIMESTAMP('%Y-%m-%d', PARSE_TIMESTAMP('%y%m%d', date_column))) >= '2022-01-01' AND DATE(FORMAT_TIMESTAMP('%Y-%m-%d', PARSE_TIMESTAMP('%y%m%d', date_column))) <= '2022-01-31'