Re: [sqlalchemy] Pass timestamp with milliseconds to SQLAlchemy backed by SQLite3

2019-07-25 Thread Mike Bayer
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 s

[sqlalchemy] Pass timestamp with milliseconds to SQLAlchemy backed by SQLite3

2019-07-24 Thread Konrad Reiche
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