select * from zaiko where createtime between (now() - interval ‘3 Days‘) and now() ; select * from zaiko where createtime between (now() - interval ‘5 Mins‘) and now()
postgre查询一段时间内的数据
原文:https://www.cnblogs.com/xiaoliu66007/p/11345137.html