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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.