Hi,

Sorry if this is an obvious question but I can't find the answer,
perhaps my Google-fu is weak.

I have a table 'Item' with an 'expires' DateTime column, I want to
test it against now() and check whether the item in the table is out
of date.

I've tried:

session.query(Item).filter(Item.expires < now()).all()

and it returns 0 results no matter what is in the 'expires' column.

The few references I can find to working with DateTime talk about
doing DB specific conversions but they were from several years ago and
I wonder if things have been fixed since.

Thanks for your help

Ben



-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to