title: Django remove Timezone
body: <p>I'm doing a query on a table in postgres with a datetime field with timezone support. I'm doing a distinct select to group all the results by hours in the day.</p>
  
  <pre><code>footage = IpCameraFootage.objects.filter(ipCamera=c, start__gte=start, end__lte=end).extra(select={'hours': "to_char(start,'dd/mm/yyyy hh24')"}).values_list('hours', flat=True).distinct().order_by('hours')
  </code></pre>
  
  <p>This is all working great however when I iterate over the results. It's applying a timezone conversion. I'm trying to get the direct value from the database without the timezone. For example, if it's returning a value of:</p>
  
  <pre><code>05/03/2013 07
  </code></pre>
  
  <p>When I access the hours variable in a django view using the following:</p>
  
  <pre><code>for f in footage:
     print f
  </code></pre>
  
  <p>the value is:</p>
  
  <pre><code>04/03/2013 21
  </code></pre>
  
  <p>Any ideas how to get the result that's it's supposed to be?</p>
  
  <p>Cheers,</p>