n0531m/date_range.sql

Last active November 21, 2025 09:49

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

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/n0531m/be7fd875ad010c43398d032ac6bba492.js"></script>
Save n0531m/be7fd875ad010c43398d032ac6bba492 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