python - sqlalchemy: dividing timedelta column by float giving strange results -

python - sqlalchemy: dividing timedelta column by float giving strange results -

i'm trying perform manipulation on column within query. want split timedelta column 60. unfortunately giving unusual results.

in query homecoming 2 datetimes, timedelta between these 2 datetimes, , timedelta between these 2 datetimes divided 2. illustration of output:

(datetime.datetime(2013, 1, 1, 0, 0, 8), datetime.datetime(2013, 1, 1, 0, 7, 32), datetime.timedelta(0, 444), decimal('362.0000'))

however, timedelta 444 divided 2 not equal 362.0000. sqlalchemy giving me. there anyway right result?

its of import manipulation in query because trying utilize above subquery , average on results i'm getting unusual averages well.

here query:

sub = session.query( merge.c.time_received, merge.c.time_sent, func.timediff( merge.c.time_sent, merge.c.time_received ), func.timediff( merge.c.time_sent, merge.c.time_received ) / 2.0 ). \ filter( merge.c.time_received != none, merge.c.time_sent != none, ). \ limit(1)

i not sure happens when split time number. maybe converting seconds first using time_to_sec(time) trick.

i assumed mysql` used.

python datetime sqlalchemy timedelta