mysql 毫秒比较_mysql 毫秒数比较的问题

最新推荐文章于 2021-02-02 20:44:13 发布

weixin_39583162

最新推荐文章于 2021-02-02 20:44:13 发布

阅读量222

点赞数

文章标签： mysql 毫秒比较

本文链接：https://blog.csdn.net/weixin_39583162/article/details/113348751

版权

mysql> select now() ;

+---------------------+

| now() |

+---------------------+

| 2014-09-09 10:20:43 |

+---------------------+

1 row in set (0.00 sec)

select * from timer t where t.shop_uid='B831B3099B73342BADCC197700EE938F' and t.type='rds.orders.task' and t.time < now();

Empty set (0.01 sec)

mysql> select * from timer t where t.shop_uid='B831B3099B73342BADCC197700EE938F' and t.type='rds.orders.task' and 1410227100035<1410229370000;

+------------------+-----------------+---------------+----------------------------------+---------------+

+------------------+-----------------+---------------+----------------------------------+---------------+

+------------------+-----------------+---------------+----------------------------------+---------------+

1 row in set (0.00 sec)

使用t.time < now(); 之前是没问题,现在就有问题了.

改为

select * from timer t where t.shop_uid='B831B3099B73342BADCC197700EE938F' and t.type='rds.orders.task' and t.time < (UNIX_TIMESTAMP(NOW()) * 1000);

+------------------+-----------------+---------------+----------------------------------+---------------+

+------------------+-----------------+---------------+----------------------------------+---------------+

+------------------+-----------------+---------------+----------------------------------+---------------+

关注