Hello, Not tested with recent web2py version, but in 2.9.5 this lead to a no where clause query :
db(db.table.datefield.year == 2010).select(db.table.ALL) gives : SELECT * FROM table Instead of SELECT * FROM table WHERE EXTRACT(YEAR FROM datefield) = 2010 For instance with postgres... I have the issue with postgres and psycopg and web2py 2.9.5 I don't have time to check in recent version... So posted here before open a ticket to pydal if issue is still there... Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.