asset 是表名吧？ select * from asset where end_time between sysdate -7 and sysdate -3 或者select * from asset where end_time >=sysdate -7 and end_time <= sysdate -3
