Hi again, can I use SQLBuilder in some way to perform the query below, so that I 1) do not have to write SQL directly and 2) can avoid the manual conversion to a date object?
for row in connection.queryAll( 'SELECT DISTINCT date(entry.begin) FROM %s WHERE %s' % ( ', '.join( query.tablesUsed() ), connection.sqlrepr( query ) ) ): entryDate = row[ 0 ] # MySQLdb returns datetime.date objects. # pysqlite returns unicode objects of the form u'2007-08-19'. if not isinstance( entryDate, datetime.date ): entryDate = datetime.datetime.strptime( entryDate, '%Y-%m-%d' ).date() # do something with entryDate here Kind regards, Markus ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss