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.
