example querying by date

models.py

from datetime import date, datetime
from django.db import models


class Foo(models.Model):
    day = models.DateField()
    created = models.DateTimeField()

    def __unicode__(self):
        return "{}".format(self.day)


def test():
    # Create some objects
    sample_dates = [
        (date(2016, 9, 1), datetime(2016, 9, 1, 13, 30)),
        (date(2016, 8, 1), datetime(2016, 8, 1, 13, 30)),
        (date(2016, 7, 1), datetime(2016, 7, 1, 13, 30))
    ]
    for d, dt in sample_dates:
        Foo.objects.create(day=d, created=dt)

    # Query examples.
    for f in Foo.objects.filter(day__gte=date(2016, 1, 1)):
        print(f.day, f.created)

    for f in Foo.objects.filter(day__gte=datetime(2016, 8, 1)):
        print(f.day, f.created)

    for f in Foo.objects.filter(created__gte=datetime(2016, 8, 1, 12)):
        print(f.day, f.created)

    # Delete our objects.
    Foo.objects.all().delete()