hi all, I've been trying to work out some SQLalchemy code to query two datetime columns and choose the one closest in time. I have some code that does this, but it requires using PostgreSQL and looks a little messy:
query = query.order_by("ABS(EXTRACT(EPOCH FROM (header.utdatetime - :utdatetime_x)))").params(utdatetime_x= self.header.utdatetime) I've been working on a piece of code that is all SQLalchemy, but I keep getting an error that I can't use the absolute value function on an interval and casting the interval to Numeric isn't working either: query = query.order_by(func.abs(cast(Header.utdatetime - self.header.utdatetime, Numeric())).asc()) any help would be greatly appreciated. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.