Date field expression raw query returns unicode instead of datetime object in sqlite

[Robin]

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.

[Daniel F Moisset]

The problem here is that you're using an expression, not a column name. The raw queryset maps all columns to the correct fields, but if you use arbitrary expressions it lets the db value through... and sqlite has no datetime values, just numbers and unicode strings.

[Ramiro Morales]

So, unfortunately we can't fix this in Django because that means it would need to interpret all raw SQL queries and deduce the correct data type of the query result. Closing as wontfix