日期比较相差30天

xrqsjj 发布于 2008-01-10 12:38， 725 次点击

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

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

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

1 回复

neu_li2008-01-10 15:15

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