title: Python/Django MySQL Datetime handling and timezone
body: <p>I've got a model called <code>Vote</code> with a field <code>date</code> :</p>
  
  <pre><code>date = models.DateTimeField(auto_now_add=True)
  </code></pre>
  
  <p>When I add an element, the date in MySQL is an UTC date but I live in UTC+2 timezone</p>
  
  <p>I think I correctly set the timezone in <code>settings.py</code> :</p>
  
  <pre><code>TIME_ZONE = 'Europe/Paris'
  </code></pre>
  
  <p>Python use the right timezone :</p>
  
  <pre><code>&gt;&gt;&gt; print datetime.datetime.now()
  2013-07-03 09:05:04.474000
  </code></pre>
  
  <p>MySQL too :</p>
  
  <pre><code>&gt; SELECT NOW( )
  2013-07-03 09:00:48
  </code></pre>
  
  <p>I could set the date attribute manualy, it works but I would like to know why auto_now_add return a wrong date although python and mysql use the right timezone</p>
  
  <p>Thank you</p>