mysql返回数据只要年月日_MySQL支持按年月日查询

在业务中需要做个类似发售日历的功能，需要按天或者按月查询分类
查询当天：
第一种：

SELECT
	*
FROM
	test
WHERE
	YEAR ( create_time ) = YEAR ( now( ) )
	AND MONTH ( create_time ) = MONTH ( now( ) )
	AND DAY ( create_time ) = DAY ( now( ) )

第二种

SELECT
	*
FROM
	test
WHERE
	date( create_time ) = curdate( );

第三种

select * from test where to_days(create_time) = to_days(now())

查询当月

SELECT
	*
FROM
	test
WHERE
	YEAR ( create_time ) = YEAR ( now( ) )
	AND MONTH ( create_time ) = MONTH ( now( ) )

查询当年

SELECT
	*
FROM
	test
WHERE
	YEAR ( create_time ) = YEAR ( now( ) )