I have the following model:

class Statistic(models.Model):
  meter = models.ForeignKey(Meter, on_delete=models.CASCADE, db_index=True)
  timestamp_start = models.DateTimeField(db_index=True)
  timestamp_end = models.DateTimeField(db_index=True)
  usage_start = models.DecimalField(max_digits=10, decimal_places=3)
  usage_end = models.DecimalField(max_digits=10, decimal_places=3)
  return_start = models.DecimalField(max_digits=10, decimal_places=3)
  return_end = models.DecimalField(max_digits=10, decimal_places=3)

I have the following value in the first record of timestamp_start in my sqllite database

2016-12-22T06:15:30.420+02:00

When I run the following query:

statistics = Statistic.objects.filter(id=1)
  .annotate(timestamp=Trunc('timestamp_start','day', output_field=DateTimeField()))
  .values('timestamp')
  .annotate(usage_start = Min('usage_start'))

timestamp results in None

QuerySet [{'usage_start': Decimal('136.972'), 'timestamp': None}]

When I attach the debugger and check the first records of my statistics table like this

Statistics.objects.all()[0].timestamp_start

it returns:

datetime.datetime(2016, 12, 22, 6, 0)

Before facing this problem I got this exception:

Database returned an invalid datetime value. Are time zone definitions for your database and pytz installed?

I do have pytz installed. But no idea how to fix this. Is the value incorrect ? Anyway in the end I set use_tz in settings.py to false. The exception vanisched but trunc returns none now. Is this causing the problem?

p.s.: My environment Python 3, Django, Sql lite database, windows