Re: [SQLObject] Distinct value lookup on DateTimeCol()

[F.A. P. <f_...@ly...>]

Hi Oleg,

I found nothing on SQLite to access the subfields of a datetime object.
Only datetime math is supported by SQLite not as a data type in the 
database.

I moved back to:

class Birthday(sqlobject.SQLObject):
     day = IntCol()
     month = IntCol()
     year = IntCol()
	

This gives me back the select on year,month and day.

IF you think the above move is a bad one after all, I would love to hear 
your idea's.


Thanks,


Frans.