id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 14569,Date field expression raw query returns unicode instead of datetime object in sqlite,Robin,nobody,"Using sqlite {{{ >>> m = MyModel.objects.raw('select id,max(date_added) as d from app_modelname group by id') >>> m[0].d u'2010-10-26 04:11:33.123513' }}} Whereas with postgresql {{{ >>> m[0].d datetime.datetime(2010, 10, 26, 4, 11, 33) }}} I believe the result returning a datetime object by postgresql is correct, whereas sqlite is not. ",,closed,"Database layer (models, ORM)",1.2,,wontfix,raw query date sqlite postgresql,,Unreviewed,0,0,0,0,0,0