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

[Kenneth Lundström]

> How do I use DAL to query by exact date?

db((db.events.created_on < datetime(date_of_day+1 
0.00.00)&(db.events.created_on > datetime(date_of_day 0.00.00)).select()

Or then you need to save even just the date of the event, not datetime 
as created_on saves.

I might be totally wrong but this should work.


Kenneth


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.