在楼上写的sql语句的基础上再加上两个条件就行了，如下：select stime,etime,(etime-stime)*24*3600 from Awhere stime>'2013-01-20 17:53:28' and stime<'2015-01-20 17:53:28';
select stime,etime,(etime-stime)*24*3600 from a
