Mysql查询5分钟内数据的sqlselect requestUrl, userHome, state, from_unixtime(RequestModifyTime/1000)
Mysql查询5分钟内数据的sql
select requestUrl, userHome, state, from_unixtime(RequestModifyTime/1000) from BlogMoveRequest where type='qzone' and RequestModify
Time/1000 > unix_timestamp('2010-03-28 10:45:00') and RequestModifyTime/1000 < unix_timestamp('2010-03-28 10:50:00');