Re: [web2py] Re: DAL Query by Date on Datetime Field.

[Vasile Ermicioi]

a bit longer but selects by exact date

dt = request.now

rows = db(
    (db.events.created_on.year()==dt.year) &
    (db.events.created_on.month()==dt.month) &
    (db.events.created_on.day()==dt.day)
).select()