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

待我称王封你为后i 2023-01-12 14:56 147阅读 0赞

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);

\+------------------+-----------------+---------------+----------------------------------+---------------+

\+------------------+-----------------+---------------+----------------------------------+---------------+

\+------------------+-----------------+---------------+----------------------------------+---------------+

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关毫秒数转时分秒

相关 mysql添加毫秒级时间

相关获取当前时间毫秒数和获取某一日期时间的毫秒数。用在比较时间

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

相关 mysql存入毫秒级的时间

相关 MySQL的Timestamp插入丢失毫秒的问题

相关 mysql datetime类型精确到毫秒、微秒的问题

相关 mysql解决datetime与timestamp精确到毫秒的问题

相关 MYSQL中时间毫秒数转换及日期格式化

相关 mysql中毫秒的保存类型