select * from a where to_number(to_char(trunc(aab022),'yyyymmdd')) - to_number(to_char(trunc(aab110),'yyyymmdd')) <= 16少年是varchar 不是varcher 而且时间怎么能是varcher呢,最好是date或者timestamp类型