title: Python / Django templates timezone issue
body: <p>I am having the following issue, and cant figure out what i am missing here.</p>
  
  <p>I have enabled the Timezone in the settings.py</p>
  
  <h2>Settings.py</h2>
  
  <p><code>TIME_ZONE = 'America/Chicago'</code></p>
  
  <p><code>USE_TZ = True</code></p>
  
  <h2>Use-case</h2>
  
  <p>Now, when I have created an object at 3.15pm (Local time), and i get the following date stored in my <code>created_at</code> field in database. </p>
  
  <p><code>created_at = models.DateTimeField(auto_now_add=True)</code></p>
  
  <p><code>2014-12-12 11:03:48</code></p>
  
  <p>When i render that date in my templates i get the following value. </p>
  
  <p><code>{{ image.created_at }}</code> = >
  <code>Dec. 12, 2014, 5:03 a.m.</code></p>
  
  <h2>TEST CASE</h2>
  
  <pre><code>    from datetime import datetime
      from dateutil.tz import tzutc, tzlocal
  
      utc = datetime.now(tzutc())
      print('UTC:   ' + str(utc))
  
      local = utc.astimezone(tzlocal())
      print('Local: ' + str(local))
  </code></pre>
  
  <p>I am getting correct datetime here. And when i use <code>myobject.created_at.astimezone(tzlocal())</code> it also returns correct. but its when in Templates i get 1 hour ahead time. WHY? i tried both <code>|local</code> filter also but no use</p>
  
  <p>What am I missing?</p>