Hi there - We would need some context for this.
What does CREATE TABLE look like? What is the datatype in use? What does the logging output say, e.g. illustrate the SQL and result output with create_engine(..., echo='debug'). It looks like you are using some epochal oriented datatype but no such datatype is included with SQLAlchemy. On Wed, Jul 24, 2019, at 7:32 PM, Konrad Reiche wrote: > Hello everyone, > It seems SQLAlchemy doesn't translate `filter` with a timestamp having > fractional seconds properly to SQLite3: > `.filter(User.created_at <= 1564004268.302929)` > But from what I've observed via debugging, only the seconds are passed to > SQLite3 via SQLAlchemy. What's the correct way of performing this query? > Best, > Konrad > > > -- > 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 view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/da07ce3b-b6cf-4d41-92be-ead3f14e6809%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/da07ce3b-b6cf-4d41-92be-ead3f14e6809%40googlegroups.com?utm_medium=email&utm_source=footer>. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/b30d1893-b502-4ed6-b442-f3db4f7eb637%40www.fastmail.com.