[web2py] Re: GROUP BY Date, Ignore Time

2011-05-30 Thread Neodudeman
Awesome. Exactly what I needed, thank you. On May 29, 4:14 pm, Massimo Di Pierro massimo.dipie...@gmail.com wrote: set = db(db.posts.id).select(db.posts.posted_date, count, groupby=db.posts.posted_date.year()|db.posts.posted_date.month()| db.posts.posted_date.day()) On May 29, 2:42 pm,

[web2py] Re: GROUP BY Date, Ignore Time

2011-05-30 Thread Massimo Di Pierro
notice you can also do: post_date=db.posts.posted_date.year()|db.posts.posted_date.month()| db.posts.posted_date.day() set = db(db.posts.id).select(db.posts.posted_date, count,groupby=pos_date) in case you need it in more than once place. On May 30, 6:38 pm, Neodudeman tams...@gmail.com wrote:

[web2py] Re: GROUP BY Date, Ignore Time

2011-05-29 Thread Massimo Di Pierro
set = db(db.posts.id).select(db.posts.posted_date, count, groupby=db.posts.posted_date.year()|db.posts.posted_date.month()| db.posts.posted_date.day()) On May 29, 2:42 pm, Neodudeman tams...@gmail.com wrote: Hi web2py; I've got some problems. I'm attempting to get a count of some rows based on