vilmid/month.sql

Last active October 4, 2021 05:18

Star (0) 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/vilmid/998d7786b031315d40a6fef8529c233b.js"></script>
Save vilmid/998d7786b031315d40a6fef8529c233b to your computer and use it in GitHub Desktop.

Download ZIP

Raw

	SELECT
	day::date
	FROM
	generate_series(current_date - interval '30 day', current_date, '1 day') AS day
	;

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