Flask 学习-94.Flask-SQLAlchemy 按日期时间查询

from datetime import datetime, timedelta  

# 获取当前时间  
print(datetime.now())  

# 前七天  
print(datetime.now() - timedelta(days=7))  

# 前2个小时  
print(datetime.now() - timedelta(hours=2))  

# 前15分钟  
print(datetime.now() - timedelta(minutes=15))  

# 前30秒  
print(datetime.now() - timedelta(seconds=30))

2022-11-14 10:13:41.712896
2022-11-07 10:13:41.712896
2022-11-14 08:13:41.712896
2022-11-14 09:58:41.712896
2022-11-14 10:13:11.712896

from datetime import datetime, timedelta

time_now = datetime.now()

# 最近 30 天数据
Students.query.filter(Students.create_time >= time_now - timedelta(days=30)).all()

# 最近 7 天数据

Students.query.filter(Students.create_time >= time_now - timedelta(days=7)).all()

# 最近 1 天数据

Students.query.filter(Students.create_time >= time_now - timedelta(days=1)).all()

# 最近 2 小时

Students.query.filter(Students.create_time >= time_now - timedelta(hours=2)).all()

# 最近 15 分钟

Students.query.filter(Students.create_time >= time_now - timedelta(minutes=15)).all()