RizkiHerdaID/Select current month and year

Created June 18, 2017 16:13

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

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

Download ZIP

Raw

Select current month and year

	SELECT *
	FROM tableA
	WHERE YEAR(columnName) = YEAR(CURRENT_DATE()) AND
	MONTH(columnName) = MONTH(CURRENT_DATE());

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