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
19473	Getting a datetime.date object for a DateTimeField when using select_related with SQL Server	Mat Moore	nobody	"Hi,

When I use select_related, and the related model has a DateTimeField, I don't get a proper datetime.datetime when I then access that field. Instead I get a datetime.date.

If I set up the following models
{{{
#!python
from django.db import models

class Author(models.Model):
    name = models.CharField(max_length=50)
    dob = models.DateTimeField()

class Book(models.Model):
    author = models.ForeignKey(Author)
}}}

And then run the following:
{{{
#!python
from books.models import Author, Book
import datetime
author = Author(name='Bob', dob=datetime.datetime(1970, 1, 1, 0, 0, 0))
author.save()
book = Book(author=author)
book.save()

print repr(Book.objects.filter(pk=book.pk)[0].author.dob)
print repr(Book.objects.filter(pk=book.pk).select_related('author__dob')[0].author.dob)
}}}

I get the output
{{{
datetime.datetime(1970, 1, 1, 0, 0)
datetime.date(1970, 1, 1)
}}}

I'm using MS SQL Server 2008 R2. I also tried running the above code with SQLLite, and in that case I get the datetime in both cases as expected."	Uncategorized	closed	Database layer (models, ORM)	1.3	Normal	invalid	select_related, datetime, datetimefield, sqlserver, db		Unreviewed	0	0	0	0	0	0