select taxi_num,taxi_reject from taxi_info where to_days(taxi_reject) -to_days(curdate()) <30

taxi_num  车号
taxi_reject  报废日期
taxi_info 车辆表




怎么不行呀。。。。我用是mysql  数据库

select taxi_num,taxi_reject from taxi_info where (taxi_reject-curdate())*24*60*60 <30*24*60*60