mysql 查询某一天的数据

select * from [table_name] where date_format([date_name],'%Y-%m-%d') = '2016-08-06'

SELECT * FROM [table_name] WHERE substring(Convert(char(10),update_time ,112),1,8)='20170927' 

SELECT * FROM [table_name] WHERE update_time between '2017-09-27 00:00:00' and '2017-09-27 23:59:59' 

SELECT * FROM [table_name] WHERE year(update_time ) = 2017 and month(update_time )= 09 and day(update_time ) = 27

SELECT * FROM [table_name] WHERE update_time > '2017-09-27' and update_time < '2017-09-28'

SELECT * FROM [table_name] WHERE ( datediff ( update_time , '2017-09-27' ) = 0 )