javidjamae/last_month.sql

Last active September 2, 2015 17:35

Star (1) 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/javidjamae/39c1ebcff8e83370dddb.js"></script>
Save javidjamae/39c1ebcff8e83370dddb to your computer and use it in GitHub Desktop.

Download ZIP

Select all records created in the last month (MySQL)

Raw

last_month.sql

	select *
	from records
	where PERIOD_ADD(DATE_FORMAT(NOW(),'%Y%m'), -1) = DATE_FORMAT(created_at,'%Y%m')

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