How to filter SQLAlchemy objects with datefield values before today?

Question

I wish to keep all objects from the database which have a particular datetime field with values before the current day. I can see how you an filter with hardcoded dates or between two dates, but how can I keep all items with dates before today?

KZiovas · Accepted Answer · 2022-10-12 11:21:56Z

0

So it seems it is quite straight forward you can do direct datetime comparison in SQLAlchemy queries like this:

    q = DBSession.query(User).filter(
        User.sign_up_date <= datetime.now() - datetime.timedelta(hours=1),
    )

which would return all user objects which signed up one hour ago.

answered Oct 12, 2022 at 11:21

KZiovas

5,0399 gold badges46 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to filter SQLAlchemy objects with datefield values before today?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related