You can try to do rows = db(...).select(....,db.table.end_time- db.table.start_time,....)
and the result should be in rows[0]._extra[db.table.end_time-db.table.start_time] but I would not trust it because it becomes dependent on the database backend. I suggest you use the standard iteration instead. Massimo On Apr 22, 10:32 am, Wes James <compte...@gmail.com> wrote: > I have a db with two time fields - start_time, end_time. > > With db.table.represent = lambda row: TABLE(.....) > > it will ouput the rows in a table. > > What I need to do is in the last column show end_time - start_time > > I'm trying to do this with represent, but I don't see a way. Is there > a way other than in a standard iteration > > for row in table: > TR(field1, field2, ...., end_time-start_time) > > In actuality I'll need to do et=datetime(date and time stuff), > st=datetime(date and time stuff) and then > > res=(st-dt).seconds > hours=res/60/60 > minutes =res/60-hours*60 > > unless anyone knows some better time math ways to do this. > > thx, > > -wj --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
