Less than date query sqlachemy

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()

Source: stackoverflow.com

Similar codes

0 vote300 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote321 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote332 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote315 views1 answer
Like date sql server not working
SQL
0 vote318 views1 answer
Sql delimiter to columns
SQL
0 vote312 views1 answer
Date on SQL
SQL
0 vote318 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
4 votes315 views2 answers
REST API
SQL
1 vote317 views1 answer
Add multiple row table pl sql
SQL
0 vote313 views1 answer
Frename oracle
SQL