SQL查询某一天的数据where条件的不同表达

	1、
SELECT * FROM cms_book_statistics WHERE substring(Convert(char(10),update_time ,112),1,8)='2021-04-02' 
 
 
 2、
 SELECT * FROM cms_book_statistics WHERE update_time between '2021-04-02 00:00:00' and '2021-04-02 23:59:59' 
 
 3、
 SELECT * FROM cms_book_statistics WHERE year(update_time ) = 2021 and month(update_time )= 09 and day(update_time ) = 27
 
 4、
 SELECT * FROM cms_book_statistics WHERE update_time > '2021-04-02' and update_time < '2021-04-02'