mysql query less than date code example

Example 1: 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()

Example 2: mysql earlier than date

mysql> select *from DatesOfOneWeek where ArrivalTime < now() - interval 1 week;