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