title: How to filter models using timezone aware dates?
body: <p>So I am trying to filter django models by date. Using either only the year, year+month, or year+month+day_of_month. The strategy I am using now is this:</p>
  
  <pre><code>n.filter(create_date__year=q)
  n.filter(create_date__year=q[:4],create_date__month=q[4:6])
  n.filter(create_date__year=q[:4],create_date__month=q[4:6],create_date__day=q[6:8])
  </code></pre>
  
  <p>Where 'q' is a date string in the format of either either 'yyyy', 'yyyymm' or 'yyyymmdd' respectively.</p>
  
  <p>This is working pretty well <strong>but</strong> django is not taking into account timezone. Django searches based on the UTC times and not the EDT, which is what the actual datetime object is set to.</p>
  
  <p>Is there a way to search the year/month/day of month based on a specific timezone?</p>