select * from 表名 where (addtime::timestamp) + '1440 min' > (now()::timestamp) addtime为时间字段名 1440 min为时间 24*60