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'
SQL查询某一天的数据where条件的不同表达
最新推荐文章于 2024-06-24 15:07:33 发布