JoanMora/date_range.sql

Forked from n0531m/date_range.sql

Created May 3, 2021 13:59

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/JoanMora/049395e1f104c0245141ed4e38a08c85.js"></script>
Save JoanMora/049395e1f104c0245141ed4e38a08c85 to your computer and use it in GitHub Desktop.

Download ZIP

BigQuery : Generate range of dates

Raw

date_range.sql

	SELECT day
	FROM UNNEST(
	GENERATE_DATE_ARRAY(DATE('2020-01-01'), DATE('2020-01-31'), INTERVAL 1 DAY)
	) as day

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment