postgrep数据库查询时间范围为一天之内的记录

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