I found strange behavior. I have a model: class User(Base): __tablename__ = 'test_user'
id = Column(Integer, primary_key=True) timeout = Column(Integer) last_receive_time = Column(TIMESTAMP) I have a next script: # run several times session.add( User( timeout=1, last_receive_time=datetime.datetime.now() )) session.commit() query = session.query(User)\ .from_statement(text(""" SELECT * FROM test_user WHERE (last_receive_time + INTERVAL '1 second' * timeout) < NOW() """)) print('amount records using NOW() = %s' % len(query.all())) This script always returns: amount records using NOW() = 0 But if we run raw sql(without alchemy) the result will be correct(not *0*). *Env:* Python 3.6.1, SQLAlchemy 1.2.8, psql (PostgreSQL) 10.4 (Debian 10.4-2.pgdg90+1) Also *I found <https://stackoverflow.com/questions/50989199/sqlalchemy-from-statement-now>* that with *params()* the query is working fine. Is it correct? Thank you. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.