import datetime dt_to = request.now dt_from = request.now - datetime.timedelta(days=1) db(db.table.dt_field >= dt_from)(db.table.dt_field < dt_to).select()
On Friday, June 20, 2014 3:16:40 AM UTC+2, web2pylover wrote: > > Can you please help me in comparing two datetime values in db? > I mean i need to select few records in db which lies between a certain > duration of time. > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.

