[web2py] DAL Query by Date on Datetime Field.

[David J.]

How do I use DAL to query by exact date?

I tried

db(db.events.created_on == request.now.date).select()

but this returned no rows?

I also tried

db(db.events.created_on.date == request.now.date).select()

but that throws an exception

Thanks.