You wrote you know how to do it with mysql. DAL doesn't care what db you 
use. Trigonometric functions are not supported by DAL anyway.
So I recommend you to apply your mysql solution using raw sql queries, 
suggested already by Alan:
http://web2py.com/books/default/chapter/29/6#Raw-sql

Reply via email to