Sorry for being retarted!
I have this:
db.define_table('test', Field('comment','string'), Field('data','datetime'))
but the function:
def getcommentsbydate():
rows = db(db.test).select(db.test.data.comment, db.test.data.date())
return dict(rows=rows)
throws an exception complaining that the date() method does not exist.
How can I exctract the date without traverse the rows object? I dont
want to use a list comprehension or something else because with
thousands of records is painfull slow (I'm thinking of a radius
accounting table ...)!
I think there is nothing in the DAL that translates to a "DATE()" sql
function, am I wrong?
Thank you for your suggestion!
