title: Rails migration set current date as default value
body: <p>I have a column date in table as:</p>
  
  <pre><code>create_table "test", :force =&gt; true do |t|
       t.date  "day"
  end
  </code></pre>
  
  <p>I want to set current date as default value for this column.
  I try as below:</p>
  
  <pre><code>create_table "test", :force =&gt; true do |t|
       t.date  "day", :default =&gt; Date.today
  end
  </code></pre>
  
  <p>But default always is Feb 1st, so if I create new record tomorrow, the day still is Feb 1st (expect is Feb 2nd)</p>
  
  <p>Thanks for response!</p>
  
  <p>Note: I use sqlite in rails 3</p>