fankay/gist:3193598

Created July 28, 2012 14:23

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/fankay/3193598.js"></script>
Save fankay/3193598 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL日期格式化函数：获取月份和天数

Raw

gistfile1.sql

	SELECT brithday FROM t_customer
	WHERE
	DATE_FORMAT(brithday,'%m-%d') >= '08-07' AND DATE_FORMAT(brithday,'%m-%d') <= '09-29'

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