Hi

I have the following statement

            rows = self.session.query(e.src_id, e.tar_id, \
                        e.type, m.text, e.event_ts).\
                        outerjoin(m, e.media_id==m.message_id).\
                        filter(e.src_id==src_id).\
                        filter(e.tar_id==tar_id).\
                        all()[start:offset]

Some of the results are like

(2L, 1L, 3, None, datetime.datetime(2012, 1, 13, 14, 52, 58))
(2L, 1L, 3, None, datetime.datetime(2012, 1, 13, 14, 52, 58))
(2L, 1L, 5, None, datetime.datetime(2012, 1, 13, 14, 52, 59))

event_ts is a Datetime object.  Is it possible to convert this to utc
in the statement?  I can do this directly with the mysql select
statement, but not sure about if this is possible in sqlalchemy

TIA
-mason

-- 
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.

Reply via email to