I am using web2py 2.2.1 . I did import time in db.py still the error , epoch is not defined.
What did i do wrong? Ashraf On Saturday, November 24, 2012 7:13:18 AM UTC+3, apps in tables wrote: > > sorry, I need to use 2.1.1 or above. > > On Saturday, November 24, 2012 6:57:33 AM UTC+3, apps in tables wrote: >> >> Hi Niphlod, >> >> I got >> >> <type 'exceptions.NameError'>(global name 'epoch' is not defined) >> >> I am using version 2.0.9 >> >> What did i miss? >> >> Ashraf >> >> On Friday, November 23, 2012 1:54:31 AM UTC+3, Niphlod wrote: >>> >>> Mind that the functionality is database dependant, hence you won't get >>> the same results changing the db engine. Moreover you get different >>> "rounding" errors trying to subtract similar dates. >>> >>> Recent web2py's DAL supports an "epoch()" method that returns "seconds >>> passed since 1-1-1970". If you can live with that, it's more deterministic >>> and safer and works in the same way in all engines (e.g., need to develop >>> on sqlite and in production use postgresql) and its functionality is >>> supported on practically every db. >>> >>> On Thursday, November 22, 2012 9:55:04 PM UTC+1, dederocks wrote: >>>> >>>> Hi, >>>> >>>> If you have two datetime fields dta and dtb, a db().select(dta-dtb) >>>> will return zero using the sqlite db, but a correct value if you use >>>> postgresql for example. >>>> The trick to make it work is to replace dta by julianday(dta) in the >>>> select, e.g. db().select(julianday(dta)-julianday(dtb)). >>>> >>>> I guess not that easy to fix, especially since this substitution would >>>> have to operate only when a datetime delta is computed? >>>> >>>> Or is there a way to do it I havent't found? >>>> >>>> Andre >>>> >>> --
