Doing DateTime Comparisons in Filter SQLAlchemy

If you switch the < to a > you can get all subjects within the last ten weeks:

current_time = datetime.datetime.utcnow()

ten_weeks_ago = current_time - datetime.timedelta(weeks=10)

subjects_within_the_last_ten_weeks = session.query(Subject).filter(
    Subject.time > ten_weeks_ago).all()

Filter generates a WHERE clause which includes results matching the clause. So the results are not “filtered out” but are included.