I think this is now fixed. please check it in trunk. On Feb 11, 12:48 am, Alexey Nezhdanov <[email protected]> wrote: > Hi. > Sorry, didn't check if that bug still exists in latest version. > Here is the problem: in Oracle substracting one datetime column from the > other gives the floating number (days). > However the web2py considers the result to be another datetime, so this Set > produces invalid condition string: > > (Pdb) print (table.time_stop-table.time_start)>300/24.0/3600 > (PINGER_RESULTS.time_stop-PINGER_RESULTS.time_start)>to_date('0.00347222222222','yyyy-mm-dd > hh24:mi:ss') > > I worked around it with: > 31 diff = (table.time_stop-table.time_start) > 32 diff.type = 'double' > 33 import pdb;pdb.set_trace() > > (Pdb) print diff > 3600.0/24/3600 > (PINGER_RESULTS.time_stop-PINGER_RESULTS.time_start)>0.041666666666666664
-- You received this message because you are subscribed to the Google Groups "web2py-users" 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/web2py?hl=en.
