阅读背景:

如何获取表格中的记录列表,其中使用DATEDIFF函数找到的时间差在两个变量之间进行选择查询?

来源:互联网 
SET @startdate = (select LOG_TIME from log.time where sender='Japan' and receiver ='USA' and code=158);

SET @enddate = (select LOG_TIME  from log.time where sender='Japan' and receiver ='USA' and code=189);

select * from log.time where  DATEDIFF(minute, @startdate, @enddate) >= 10;
SET @startdate = (select LOG_TIME from log.time



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: