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. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss