Re: [sqlalchemy] Custom utcnow function and session.execute yields a constant timestamp

Thats the issue indeed, thanks! On Wed, Mar 28, 2018 at 11:05 PM, Jonathan Vanasco wrote: > in postgres > > returns the start of the current transaction: > NOW() > CURRENT_DATE > CURRENT_TIME > CURRENT_TIMESTAMP > LOCALTIME > LOCALTIMESTAMP > > returns the actual time: >

Re: [sqlalchemy] Custom utcnow function and session.execute yields a constant timestamp

in postgres returns the start of the current transaction: NOW() CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP LOCALTIME LOCALTIMESTAMP returns the actual time: clock_timestamp() timeofday() -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post

Re: [sqlalchemy] Custom utcnow function and session.execute yields a constant timestamp

try calling it in a new transaction, it's likely constant per transaction time. $ psql -U scott test psql (9.6.8) Type "help" for help. test=# begin; BEGIN test=# select now(); now -- 2018-03-28 15:03:09.82421-04 (1 row) test=# select now();

[sqlalchemy] Custom utcnow function and session.execute yields a constant timestamp

Hi, I've created the following utcnow function as described here: http://docs.sqlalchemy.org/en/latest/core/compiler.html?highlight=utc#utc-timestamp-function from sqlalchemy.ext.compiler import compiles from sqlalchemy.sql import expression from sqlalchemy.types import DateTime, String class