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
11851	.annotate() turns datetime fields to unicode with sqlite3	aminc	nobody	"I have two models, joined with a !ManyToManyField:
{{{
class MainModel(models.Model):
    date = models.DateTimeField(auto_now_add=True)
    others = models.ManyToManyField('OtherModel')

class OtherModel(models.Model):
    pass
}}}

I set up a sample dataset:
{{{
>>> m = MainModel.objects.create()
>>> for i in range(12):
>>> ... m.others.create()
}}}

But when I use queryset annotation, my !DateTimeField is giving me the raw unicode value:

{{{
>>> MainModel.objects.annotate(num_others=Count('others')).get().date
u'2009-09-08 12:54:17.380000'

>>> MainModel.objects.get().date
datetime.datetime(2009, 9, 8, 12, 54, 17, 380000)
}}}

These are my sqlite tables:
{{{
sqlite> .schema news_mainmodel
CREATE TABLE ""news_mainmodel"" (
    ""id"" integer NOT NULL PRIMARY KEY,
    ""date"" datetime NOT NULL
);
sqlite> .schema news_othermodel
CREATE TABLE ""news_othermodel"" (
    ""id"" integer NOT NULL PRIMARY KEY
);
}}}"		closed	Database layer (models, ORM)	1.1		duplicate			Unreviewed	0	0	0	0	0	0