haha you guys make it so easy for us and yet we still can't get. Thanks so
much for your help! I think that'll do me just fine.
On Thu, Jan 27, 2011 at 3:57 PM, Michael Bayer <mike...@zzzcomputing.com>wrote:
> you can emit that exact SQL using func.abs() in conjunction with the
> extract() function, which is a standalone SQLA construct.
>
> from sqlalchemy import func, extract
>
> func.abs(extract('epoch', header.udatetime - self.header.udatetime))
>
>
> On Jan 27, 2011, at 4:21 PM, Petra Clementson wrote:
>
> > 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<sqlalchemy%2bunsubscr...@googlegroups.com>
> .
> > For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
> --
> 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<sqlalchemy%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
--
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.
