DATE_SUB(NOW(),INTERVAL5MINUTE)与DATE_FORMAT(DATE_SUB(NOW(_MySQL

来源：懂视网责编：小采时间：2020-11-09 18:40:45

DATE_SUB(NOW(),INTERVAL5MINUTE)与DATE_FORMAT(DATE_SUB(NOW(_MySQL

DATE_SUB(NOW(),INTERVAL5MINUTE)与DATE_FORMAT(DATE_SUB(NOW(_MySQL:bitsCN.com DATE_SUB(NOW(),INTERVAL 5 MINUTE)与DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 MINUTE),'%Y-%m-%d %H:%M:%S')[sql] [root@CactiEZ ~]# time mysql -h 172.22.10.32 -ucacti -

推荐度：

点击下载本文 文档为doc格式

导读DATE_SUB(NOW(),INTERVAL5MINUTE)与DATE_FORMAT(DATE_SUB(NOW(_MySQL:bitsCN.com DATE_SUB(NOW(),INTERVAL 5 MINUTE)与DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 MINUTE),'%Y-%m-%d %H:%M:%S')[sql] [root@CactiEZ ~]# time mysql -h 172.22.10.32 -ucacti -

bitsCN.com

DATE_SUB(NOW(),INTERVAL 5 MINUTE)与DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 MINUTE),'%Y-%m-%d %H:%M:%S')[sql] [root@CactiEZ ~]# time mysql -h 172.22.10.32 -ucacti -P3316 -pcacti -e "select count(*) from order.tbl_tieyou_order where order_time > DATE_SUB(NOW(),INTERVAL 5 MINUTE);" -N +-----+ | 112 | +-----+ real 0m0.030s user 0m0.005s sys 0m0.003s [root@CactiEZ ~]# time mysql -h 172.22.10.32 -ucacti -P3316 -pcacti -e "select count(*) from order.tbl_tieyou_order where order_time > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 MINUTE),'%Y-%m-%d %H:%M:%S'); -N" +----------+ | count(*) | +----------+ | 365 | +----------+ real 0m1.602s user 0m0.008s sys 0m0.003s DATE_SUB(NOW(),INTERVAL 5 MINUTE) DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 5 MINUTE),'%Y-%m-%d %H:%M:%S')

数据不一致呢？

这2个语句有什么区别？

直觉告诉我肯定是格式不对的缘故，于是亲自做了测试