Hi,
How can I add one column containing integer values (NULL allowed), treating
them as seconds, to another column from the same table containing datetime
values and compare the result to the current time?
I have a table with a datetime column "finished_on" and in int column "wait".
Once wait seconds have passed since finished_on, I need to do something with
that row. In postgres, the query to find these rows would look something like
this:
SELECT * FROM test WHERE finished_on + INTERVAL '1 sec' * wait < NOW();
How can I make a query like that in sqlalchemy?
I have tried googling the problem, but the only solutions I found where those
where you already have the interval value available in the calling python
code. This doesn't help me here, since the interval can be different for each
row.
Regards,
Guido W.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
